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.