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
EditCopy, EditPaste Special, check Values and then review the macro.

--
Regards,

Niek Otten
Microsoft MVP - Excel

"david" wrote in message
...
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

Edit / Copy then Edit / Paste Special / Values

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------



"david" wrote in message
...
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