How to code with the R1C1 Style of Reference?

P

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
 
B

Bob Phillips

Cells(row_num,Col_num).Select

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
P

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
 
D

Dave Peterson

I'm not Bob, but you could try:

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

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

Top