I need to create a macro that inserts another line, formatting the line just like the one above it, and also copying any formulas in that line to the new line. I have the macro created that copies the formatting, but it does not copy the formula.

Take a look at David McRitchie's InsrtRow macro:

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

In article ,
"Tina Marie" wrote:

I need to create a macro that inserts another line, formatting the line just
like the one above it, and also copying any formulas in that line to the new
line. I have the macro created that copies the formatting, but it does not
copy the formula.