Convert A1 notation to string without dollar signs

  • Thread starter Thread starter eholz1
  • Start date Start date
E

eholz1

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

| 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert a range t ype to a string type 5
Trying to evaluate cell referenes in a string 3
String converted to date 7
convert R1C1 (international) address to A1 0
Convert String of 512 numbers to a range 10
Converting String numbers into real numbers 2
Converting String numbers into real numbers 1
Special string convertion to date and time 4

Back
Top