Excel Macro to insert a new row

Yes but, what I didn"t say earlier is that the entered data is several thousand lines of long rows of data segmented along several categories.

These, asset registers get updated by many different people in various countries with varying degrees of comfort with worksheets.

Invariably, they will insert a new row in a manner that ends-up messing up the format and formulas imbeded within it...then the'll try to fix it and end-up messing something else.

THAT'S WHAT I'M TRYING TO PREVENT. By adding a macro that inserts a perfectly formated new row at some logical point within the segmented worksheets.

This is easy enough to do by just recording a macro then going through the right steps on how to insert and format a row, then saving the macro.

The problem is, that such macro will always insert the row in the same "address" or "spot" that it was originally recorded...rather than immediately above ANY cell that the mouse has clicked on before keying in the macro.

This variable (checking a series of cells (rows) with data along a column, stopping the cursor at the blank cell at the bottom of the series of filled-in rows and inserting a new formatted row immediately above the blank row) is probably easy enough to code in VB...except that I'm not that familiar with VB which is why I'm seeking help here.

Thanks for asking and for any suggestions you may have.

If the issue is the row location, then find out the new row

Lets say column A will always have a values

lLastRow = Cells(Rows.count, "A").end(xlup).row

This gives you the last used row (unless you sheet is blank in which case it is 1)