Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to code with the R1C1 Style of Reference?
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 -- I keep hitting "Esc" -- but I'm still here! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to code with the R1C1 Style of Reference?
Cells(row_num,Col_num).Select
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "plh" wrote in message ... 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 -- I keep hitting "Esc" -- but I'm still here! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to code with the R1C1 Style of Reference?
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 In article , Bob Phillips says... Cells(row_num,Col_num).Select -- HTH Bob Phillips (remove nothere from email address if mailing direct) "plh" wrote in message ... 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 -- I keep hitting "Esc" -- but I'm still here! -- I keep hitting "Esc" -- but I'm still here! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to code with the R1C1 Style of Reference?
I'm not Bob, but you could try:
Debug.Print Sheets("Parts List").Cells(5, 2).Name.Name plh wrote: 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 In article , Bob Phillips says... Cells(row_num,Col_num).Select -- HTH Bob Phillips (remove nothere from email address if mailing direct) "plh" wrote in message ... 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 -- I keep hitting "Esc" -- but I'm still here! -- I keep hitting "Esc" -- but I'm still here! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
R1C1 Reference Style Default | Excel Discussion (Misc queries) | |||
R1C1 reference style | Excel Discussion (Misc queries) | |||
can a1 reference style and r1c1 style be used in same formula? | Excel Worksheet Functions | |||
R1C1 Reference Style won't STAY gone? | Excel Discussion (Misc queries) | |||
R1C1 reference style | Excel Discussion (Misc queries) |