View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ragtopcaddy via OfficeKB.com ragtopcaddy via OfficeKB.com is offline
external usenet poster
 
Posts: 22
Default convert A1 to R1C1 in VBA

Is there a function that will do the following?:

convtA1toR1C1(strA1 As String) As String

So that with the following input I would get the following return?

convtA1toR1C1("F23:AL4257") = "R23C6:R4257C38"

Thanks,

--
Bill Reed

"If you can't laugh at yourself, laugh at somebody else"

Message posted via http://www.officekb.com