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

?range(range("a1")).Address(false,false)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"eholz1" <(E-Mail Removed)> wrote in message news:337f3aee-00d4-4977-b314-(E-Mail Removed)...
| 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

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
>

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~