How to code with the R1C1 Style of Reference?

[plh]

Is there a way to code using the R1C1 style of reference? It seems to me I have
doe it but I just can't recall it now.
That is, instead of:
Range("A1").Select
Something like:
Range(R1C1).Select
That way it would same complications past column Z
Thank You,
-plh

 

[Bob Phillips]

Cells(row_num,Col_num).Select

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[plh]

Thank you! You are obviously a knowledgeable guy!

Maybe you know the answer to this one:

Debug.Print Sheets("Parts List").Cells(5, 2).Name
gives me
='Parts List'!$B$5

but the cell has a defined name of EVANS_KO

How do I return this defined name?
Thank You,
-plh

 

[Dave Peterson]

I'm not Bob, but you could try:

Debug.Print Sheets("Parts List").Cells(5, 2).Name.Name