| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get a cell's name in VBA
Hello,
Could anyone point out how to get a cell's name in the VBA code. I am trying to retrieve a cell's name - for example suppose target is the range object pointing to a single cell. Following lines get the cell address instead of cell name. target.Name or target.Cells(1, 1).Name How do I get the cell's name instead of address? Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using 1 cell's value as a reference | Excel Discussion (Misc queries) | |||
| row= cell's row | Excel Worksheet Functions | |||
| How to change an other cell's value? | Excel Discussion (Misc queries) | |||
| returning a cell's value and a corresponding value | Excel Worksheet Functions | |||
| How do I get a cell's row number | Excel Programming | |||
Threaded Mode
