Max Row Containing Data

[nparrillo]

Hi all-

Anyone have any ideas on how to have excel return the row number for the maximum row containing data?

Thank you!

 

[Joe4]

Something like this VBA code will tell you that:

Sub Macro1()
    MsgBox Range("A1").SpecialCells(xlLastCell).Row
End Sub