Hi Jeff,

See David McRitchie's InsertRowsAndFillFormulas sub:

http://www.mvps.org/dmcritchie/excel/insrtrow.htm


---
Regards,
Norman



"Jeff Fink" <Jeff wrote in message
...
Good Afternoon,
I have a worksheet with over 500 rows. I have formulas entered in 4 of
the columns (J,K,L, & M). When I insert an entire row I get a blank row as
usual. I want to click insert entire row and have that row inserted with
the formulas from columns J,K,L, & M in that row. If anyone has any ideas
or knows how I can do this please let me know.

Thanks,
Jeff Fink