How to get the current cell position in VBA (eq. Row(), col() in F

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there any way to know the Row and Col position
when user select a cell? so I can,
MsgBox( "You are in ROW "+....+"COL"+...)

thanks so much
 
Thanks so much Mr Gary K.

MsgBox ActiveCell.row & ", " & ActiveCell.col

Will also work. Can you tell me :
1. Is there any doc or help file that I can download to explain all the
excel object (such as ActiveCell.??? )
2. What is the easiest way to get back to this post? since the page number
will keep changing...
3. How to read all the post offline ? (like reading doc or pdf...)

Thank again! Have a nice day!
Johan2000
 
Actually the correct form (the one that works) is

MsgBox ActiveCell.Row & ", " & ActiveCell.Column

Cheers
 
Back
Top