This project has moved. For the latest updates, please go here.

Is there a way to getthe max row number in the active sheet?

Nov 7, 2013 at 8:06 AM
In my project, I want to get the max row number rather than used row number

Is there a way to getthe max row number in the active sheet?
Editor
Nov 7, 2013 at 9:26 AM
Hi,

Please use worksheet.Dimension.

Regards,
Thiago
Nov 8, 2013 at 1:40 AM
Thiago,

Thanks for reply.

I found that the worksheet.Dimension return the used row number instead of max row number.

when opening a new worksheet, there are some blank default rows and columns.

Could I get the max row number and max column number in this case?