copying values

[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

 

[Niek Otten]

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.

 

[Ken Wright]

Edit / Copy then Edit / Paste Special / Values