How to get the filled rows in a excel worksheet
I have worksheet i neeed to programatically Thru a macro get the last row col combination entered.
Printable View
How to get the filled rows in a excel worksheet
I have worksheet i neeed to programatically Thru a macro get the last row col combination entered.
Here is how you can find the range for a excel work sheet
MsgBox ActiveCell.CurrentRegion.Row
MsgBox ActiveCell.CurrentRegion.Column
MsgBox ActiveCell.CurrentRegion.Rows.Count
MsgBox ActiveCell.CurrentRegion.Columns.Count
Thank you