View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
eholz1 eholz1 is offline
external usenet poster
 
Posts: 32
Default Convert A1 notation to string without dollar signs

Hello All,

Is there some sort of VBA command (without using Mid, InStr, etc)
to convert a cell address (aka string, or even single cell range) from
"$F$51" (or R51C6)
to just a string "F51".

I can parse and cut, etc for $ signs, but I thought there might be a
single command that would do this.

Thanks,

eholz1