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~
|