View Single Post
  #3   Report Post  
Yakman
 
Posts: n/a
Default How do I copy only cells with formulas in another row?

Create a macro, to insert a new line then copy the required formula down a
row.


"Soozy" wrote in message
...
I have a table with multiple formulas on each row. I need to be able to

copy
on the formulas when I insert a new row. I've tried the paste special
formulas and that copied the whole row, data included. I only want the
formulas to be copied.

Any suggestions...?