Hi Everyone

In Excel I can place the following in a cell to get the last non blank
row number in column A. This works great and it's super quick.

=ROW(OFFSET(A1,COUNTA(A:A)-1,0))

To do the same with VBA code seems very complex. Can you please show
me some VBA code that will give me the last non-blank row number for a
given column?

Andy