Rows Filled in Excel

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