Need Help Inserting new row using macros

[burnin2emax]

Hi. Hope someone can help.

I want to create a macro that inserts a new row which is specified by my cursor and then, input formulas into the newly formed rows.
I need a bit of a kickstart here. thanks man...

 

[Cbrine]

Sub InsertRow()
rows(activecell.row).entirerow.insert
End sub

Will insert a row at the activecell.

HTH
Cal

 

[burnin2emax]

Thanks...!

Thanks man... You make my day....