Get the Value of the Maximum row in a sheet

Msgbox Activesheet.Rows.Count

How to apply?

You can use this to find the last row of the UsedRange

Range(”A” & ActiveSheet.Rows.Count).End(xlUp).Select