As always, post YOUR code for comments and suggestions.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jen_T" wrote in message
...
I am very new at macros and had recorded one for a worksheet I use all the
time. I copied/pasted the macro into another workbook that I could use
this
the macro for but there is less data and has the potential to grow. In the
macro I recorded I had copied a formula and then autofilled down to last
row
of data. How do I edit the macro to find last row and copy the formula
down.
I am ending up with unecessary rows of formulas where there is no data.