create an "Insert Row" button in an excel spreadsheet

**torontoguy** · 01-15-2009, 04:15 PM

Can anyone tell me what the macro code is to do this (at whatever box I have selected at the time)

say my box is selected at E3, then when I click the button, it creates a new row E

likewise for F7, AA1, etc...

**BigBas** · 01-15-2009, 04:32 PM

Please Login or Register  to view this content.

**solnajeff** · 01-15-2009, 04:34 PM

Hi

If you create a single line macro using the following

Please Login or Register  to view this content.

then add a keyboard shortcut (Tools/Macro/Macros/Options), you can use it on any worksheet. This will insert a row above the activecell.

Regards

Jeff