I have a spreadsheet with a Macro which identifies the Active Cell and inserts a new Row in that location. Column A of the Table is for the ID number.
I want the same Macro to self populate an ID in Column A of the new Row. I need it to be +1 higher than the maximum ID number already present in that column. In case it matters, Column A is using a Special Format (000) to ensure it always contains three digits. For example the number 3 will be shown as 003. Not sure if this matters.
As Rows will not always be at the bottom of the Table I cannot do a simple increment of the line above.
And this is where i am stuck as I am not very good at VBA. Any help would be appreciated.