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

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
 
G

Guest

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
 
R

Ross Marsden

Actually the correct form (the one that works) is

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

Cheers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
A For Each in Range... with a .Find(what:="TJ", ... in it problem 15
Named Range maker code 9
Compare data set 1 with data set 2. Add to data set 2 if not found 0
HOW TO SELECT SPECIFIED RANGE IN MACRO 4
Sub to carve out uniques based on col header whose position may va 6
Trying to determine what cells within a Row have a 0 (zero) value 5
For Each Cell in Sheet1 Range, do some Vlookup calc. from Sheet3 5

Top