inserting a blank row

**Del117** · 11-22-2012, 08:01 PM

I'm looking to insert a blank row in the second last row of a workbook anybody got the right code?
also I have a Macro that runs and opens multiple workbooks only Problem is I have to have a work book open to run the macro is there a way of having an icon on desktop to run Macro?
one last thing is there a way of creating a macro to send an email of a workbook Straight from excel?
thanks Del

**jeffreybrown** · 11-22-2012, 08:11 PM

Maybe...

Please Login or Register  to view this content.

**Del117** · 11-23-2012, 07:42 PM

Thanks works a treat do you know if the rest of the querry is possible?

**Del117** · 11-23-2012, 07:46 PM

also could you explain the little bit of code so i know whats happening?

**jeffreybrown** · 11-23-2012, 08:02 PM

Hi Del,

I have never heard of a way to run a macro through desktop shortcut, but maybe a google search would turn up something.

As to the e-mail, here is a great place to get some pre-built code http://www.rondebruin.nl/tips.htm

The macro basically uses a variable called LR to look for the last filled row in column A and when found, backs up one cell to insert a new row.