Cell (X,Y) ?

[zzcom]

Range("H9") is Cell(9,5). How to know Cell's (x,y) for any cell?

 

[Norie]

Try this.

Set rng = Range("H9")

x =rng.Row
y=rng.Column

MsgBox "x=" & x & vbCrLf & "y=" & y

 

[zzcom]

Thanx a lot Norie.

 

[tusharm]

Switch to R1C1 display mode (Tools | Options > General | check 'R1C1 reference style')

Range("H9") is Cell(9,5). How to know Cell's (x,y) for any cell?