Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Oct 2001
    Location
    West Virginia
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Protecting a Cell's Value (Excel 2000)

    I have cells whose values are calculated by summing values of a range of cells from a different column. Now I'd like to sort by the column with the calculated values. Upon doing so, those values change because the values in the formula's range have changed as a result of the sort. How to get around?
    Any info much appreciated!
    Thanks,
    Eric

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Protecting a Cell's Value (Excel 2000)

    Eric

    You need to save the formula values by pasting Speical the values. From the Edit menu choose Copy and then paste Special and then from the dialog under paste choose values.

    For a VBA solution try something like Selection.PasteSpecial Paste:=xlValues

    Hope this helps

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  3. #3
    New Lounger
    Join Date
    Oct 2001
    Location
    West Virginia
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Protecting a Cell's Value (Excel 2000)

    Wassim

    Thanks for the information. Paste Special - values worked for what I needed to do.
    I appreciate it!

    Eric

Posting Permissions

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