| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set variable to active cell address
I just need to set the value of a variable to the "A1" address of the
active cell. I feel like I've tried everything, but shouldn't this work.... Dim rng as Range Set rng = activecell [results in active cell's value] Set rng = activecell.address [throws error] Thanks all, Shelton. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I use the active cell address as a value | Excel Discussion (Misc queries) | |||
| Get Address of Active Cell | Excel Discussion (Misc queries) | |||
| Find address of active cell | Excel Worksheet Functions | |||
| Getting active cell address | Excel Programming | |||
| How to get the active cell address? | Excel Programming | |||
Threaded Mode
