F5, special and select formula, then copy

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


wrote in message
oups.com...
Hi - If I have a column of cells, some being formulas, others being
numeric values, if I try to copy and do paste special "formulas" to
another column, it also copies over the values of those numeric cells
in addition to the formulas. Is there any way around this so it just
copies the formulas and does not affect the other cells if there is not
a formula in it?

Thanks!