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

  • Thread starter Thread starter korrin.anderson
  • Start date Start date
K

korrin.anderson

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!
 
If you wanted a copy of only the cells that have a formula and not the
cells that have constants, you could copy and paste the column, then,
with the pasted column selected, Edit, Go To, Special, select
Constants, and press Del to remove them, however this does not preserve
any former values in those cells, for that I think you would need some
VB code.

Does this help?

--
 
Back
Top