View Single Post
  #4   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

On Apr 8, 3:06 pm, Jim Thomlinson <James_Thomlin...@owfg-Re-Move-
This-.com wrote:
How about this...

Replace("$F$51", "$", "")
--
HTH...

Jim Thomlinson

"eholz1" wrote:
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


Wow, Good tips. have info will use, and

Thanks again!
eholz1~