It was very useful but doesn't
quite answer my question.

I need to be able to automatically via a macro to
identify the last column  and row  and then in the last
column with data  insert another column which would be
populated with row numbers. This row numbering would
"end" once the last row of data is reached.

I can send a sample file if you like.