Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    May 2002
    Posts
    69
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Paste as Value (Excel 2000)

    I have formulas scattered throughout a large excel spreadsheet. What I would like to do is be able to select only those formulas that I want to change as a value. If I select the cells, copy and paste special, I get a message "that command can not be used on multiple selections". Does anyone know how I can do this? Copying the formulas to other spreadsheets or moving things around is not an option. I need to keep the large spreadsheet intact with the exception of changing selecting cells into values.

    Any information would be great!

    Thanks in advance.

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Paste as Value (Excel 2000)

    I assume you can't just select the entire sheet, copy, and PasteSpecial Values on the whole sheet. If so, the following macro will loop through all of the cells in the current selection and Copy/PasteSpecial Values on each one.

    <pre>Public Sub ConvertToValue()
    Dim oCell As Range
    For Each oCell In Selection
    oCell.Copy
    oCell.PasteSpecial xlPasteValues
    Next oCell
    End Sub
    </pre>

    Legare Coleman

  3. #3
    Star Lounger
    Join Date
    May 2002
    Posts
    69
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Paste as Value (Excel 2000)

    Thanks a million!!! It's worked perfectly.

    <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •