| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove the $ from a cell reference
This should do the trick:
Dim CellVariabel As String CellVariabel = "$A$25" ' Or what ever CellVariabel = Replace(CellVariabel,"$","") Hope you get the idea :-) "Les" skrev i en meddelelse ... Hi, could anybody help with this please ? I need the cell reference to read A25 and not $A$25 Any help much appreciated -- Les |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to remove the cell reference in a sheet at once | Excel Discussion (Misc queries) | |||
| Remove XLA as a reference in VBA | Excel Programming | |||
| How do I remove a reference from a cell? | Excel Discussion (Misc queries) | |||
| How can I remove cell reference when calculating outside of the pi | Excel Worksheet Functions | |||
| Remove a Reference | Excel Programming | |||
Threaded Mode
