| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveCell.Address
Hey guys
The below code pulls back the active cell address. How do I get it to return only the number portion of the address? For instance if location is equal to J22, I want to retrieve only the 22. Dim Location Location = ActiveCell.Address Thank you Todd Huttenstine |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If activecell.column = variable then activecell,offset (0,1) | Excel Discussion (Misc queries) | |||
| use of activecell | Excel Programming | |||
| Activecell value | Excel Programming | |||
| how to set activecell? | Excel Programming | |||
| LINKING Address cells from an EXCEL spreadsheet to fill MapQuest Address Info | Excel Programming | |||
Threaded Mode
