Copy and Paste Special (Formulas) pastes cell value if numeric

[[email protected]]

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!

[Peo Sjoblom]

F5, special and select formula, then copy

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


<[email protected]> wrote in message
news:[email protected]...
> 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!
>