View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default 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!