Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Names of named ranges in active sheet only
Dim nm as Name, rng as Range
for each nm in thisworkbook.Names set rng = nothing on Error Resume Next set rng = nm.ReferstoRange on Error Goto 0 if not rng is nothing then if rng.parent.name = Activesheet.name then ' this name is on the same sheet end if end if Next -- Regards, Tom Ogilvy "XP" wrote in message ... In Excel 2003, is it possible to return only the Names of named ranges in the active sheet vs. the entire workbook? Could someone please post example code on how to do this? Must the range be named a certain way for the code to detect this info? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy worksheet with named ranges to new workbook and keep names | Excel Worksheet Functions | |||
Names of named ranges in active sheet only | Excel Programming | |||
union of named ranges based only on the names of those ranges | Excel Programming | |||
Copying named ranges from one sheet to another | Excel Programming | |||
How do I delete all named ranges in a sheet at one time? | Excel Worksheet Functions |