| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HOW TO: Get cell address from a range
Set the first two parameters of .Address to False:
rgeMyCell.Address(False, False) -- Regards Juan Pablo González "Kevin McCartney" wrote in message ... HI TWIMC, If I set a range to the cell B1 I'd like to be able to a get the cell address in the style of B1 not B$1$, so what code do I need to use instead of: rgeMyCell.Address TIA KM |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell address for first value to appear in a range | Excel Discussion (Misc queries) | |||
| find last cell in range with data, display cell address | Excel Worksheet Functions | |||
| Need ability to get cell address of max value in range | Excel Worksheet Functions | |||
| Cell address in a range | Excel Discussion (Misc queries) | |||
| cell address rather than range name | Excel Discussion (Misc queries) | |||
Hybrid Mode
