| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Produce the name of the named range of activecell
Hi Excel users and expert,
Excel 2002 SP3. I swear I have seen the answer to this but Google search did not get me there. I'm looking for code that does this: If active cell is in named range Data1 then call Macro1 elseif activecell is in named range Data2 then call Macro2 End If "activecell.name.name" did not work but I have to missing something. Gotta be fairly simple. I have 9 ranges and macros but I'm sure if I can get the syntax of the 2 above I can work it out. Thanks, Regards, Howard |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| produce a formulate to produce assigned seats for dinner | Excel Worksheet Functions | |||
| If any cell in named range = 8 then shade named range | Excel Programming | |||
| How to get name of named range where activecell is | Excel Programming | |||
| Copy named range contents to activecell position | Excel Programming | |||
| Finding if the activecell is withing a named range | Excel Programming | |||
Threaded Mode
