View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Copying summed cells


copyeditpaste specialpaste values
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"spitfiregp34" wrote in message
...
I am trying to copy a column of cells that I have summed from other
columns.
I then want to erase the other columns, but then when I do this the copied
column all goes to zero. Is there a way to keep the values in the copied
column after I erase the original?