copying values

  • Thread starter Thread starter david
  • Start date Start date
D

david

I have a range that I am trying to copy and paste. I only
want to copy the value in each cell though. I don't want
to copy the formulas. I can't figure out how to get it to
copy the cell.value. Any help would be great.

Thanks,
David
 
Hi David,

You can't copy just the values, but you can paste. Record a macro when doing
Edit>Copy, Edit>Paste Special, check Values and then review the macro.
 
Back
Top