| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Name of range containing ActiveCell?
Is there an easy way to get the name of the range containing the ActiveCell?
I have a macro that loops through all the names in the workbook and sees if they intersect with the ActiveCell - but isn't there an easier way? I tried ActiveCell.Range.Name, and getting the row and column references for Cells(r,c).Range.Name, but nothing worked. Ed |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I return the location (as a range) of ActiveCell? | Excel Discussion (Misc queries) | |||
| ActiveCell in a Range? | Excel Discussion (Misc queries) | |||
| Activecell, not for cell,but for range? | Excel Discussion (Misc queries) | |||
| ActiveCell.Copy Range("R3C27") | New Users to Excel | |||
| Saving the activecell range for later use | Excel Programming | |||
Threaded Mode
