first you need to select first cell and then goto last cell
as given below
so now you are in the last row
it takes you to last column
then you can find out which row and which column you are in
: If you want to know anything which is possible in EXCEL using VB
Just Record a macro with all the requirements.then study the macro code....thats it...