| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In Excel, what do the dollar signs mean in $A$1 | Excel Worksheet Functions | |||
| Dollar signs on all tabs | Excel Discussion (Misc queries) | |||
| Dollar signs in VBA | Excel Programming | |||
| Dollar signs | New Users to Excel | |||
| Dollar SIgns in Formulas | Excel Discussion (Misc queries) | |||
Threaded Mode
