F5, special and select formula, then copy

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


<korrin.anderson@gmail.com> wrote in message
news:1146588216.111145.190020@v46g2000cwv.googlegroups.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!
>