Automatic Row insert

[michal.kowalski]

I'd like to make very big table. There will be head on top, one wor will be free and there will be the data. Please how can I make the automatic adding? To the free row under the head I'd like to write some new things. Than will Excel make new row under the head and again.. So in the top will be the newest data and I needn't go to the bottom to fill new data under the table. Thanx Michal

[Palmetto]

If you don't mind use a right-click, you use the worksheet's Before_Rightclick event to insert a new row.

This code will insert a new row only if you are on row-2 (immediately below the header row) and right-click.
Will that work for you?

Please Login or Register  to view this content.

You must copy the code the code module for the data sheet.
Right click the sheet tab > View Code > copy and paste the code into the sheet module.
Close the VB Editor.

In Excel 2007 you must save the workbook as a .xlsm file type.