Cell (X,Y) ?

zzcom

Active Member
Joined
Aug 4, 2004
Messages
272
Range("H9") is Cell(9,5). How to know Cell's (x,y) for any cell?
 

Some videos you may like

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,056
Office Version
  1. 365
Platform
  1. Windows
Try this.
Code:
Set rng = Range("H9")

x =rng.Row
y=rng.Column

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

tusharm

MrExcel MVP
Joined
May 28, 2002
Messages
11,028
Switch to R1C1 display mode (Tools | Options > General | check 'R1C1 reference style')
zzcom said:
Range("H9") is Cell(9,5). How to know Cell's (x,y) for any cell?
 

Watch MrExcel Video

Forum statistics

Threads
1,118,328
Messages
5,571,564
Members
412,405
Latest member
DutchMonkey
Top