Return row # and Column # of a name reference?

  • Thread starter Thread starter Khaki
  • Start date Start date
K

Khaki

Hi,
I would like to get the row # and Column # of a name reference i
VBA.

Eg. If I name cell B200 to be "myvalue", is there a way to get th
reference by name myvalue, and get its row # and column #, like get ro
= 200 and column 2 back?

TIA
 
Khaki said:
Hi,
I would like to get the row # and Column # of a name reference in
VBA.

Eg. If I name cell B200 to be "myvalue", is there a way to get the
reference by name myvalue, and get its row # and column #, like get row
= 200 and column 2 back?
Click to expand...

Hi, just use the Column and Row properties of a range object, as:

rngColumn = Range("myvalue").Column
rngRow = Range("myvalue").Row

Regards,
 
Back
Top