View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Copy and Paste Special (Formulas) pastes cell value if numeric

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!