Thread: Translating A1 format to R1C1 format addresses?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
(PeteCresswell) (PeteCresswell) is offline
external usenet poster
  
Posts: 139
Default Translating A1 format to R1C1 format addresses?
Per (PeteCresswell):
Am I getting the .Address the wrong way?

Or do I need to be able to translate the address to RowColumn format?

Oops!

Got it.
--------------------------------------------
?myDataRange.Address(ReferenceStyle:=xlR1C1)
R2C1:R14C4
--------------------------------------------
--
PeteCresswell
Reply With QuoteReply With Quote