Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looping through named ranges
I would like to loop through named ranges in a particular worksheet. Is there a way to do this. Something like Dim MyRange As Range For each MyRange in ThisWorkbook.Worksheets("Sheet1").Ranges .....Do something.... Next MyRange however, this of course, doesn't work. Any ideas? -- JFamilo ------------------------------------------------------------------------ JFamilo's Profile: http://www.excelforum.com/member.php...o&userid=17276 View this thread: http://www.excelforum.com/showthread...hreadid=396243 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looping through named ranges
Dim nm as Name
for each nm in ThisworkbookNames or for each nm in Thisworkbook.Worksheets(1).Names for just sheet level names. -- Regards, Tom Ogilvy "JFamilo" wrote in message ... I would like to loop through named ranges in a particular worksheet. Is there a way to do this. Something like Dim MyRange As Range For each MyRange in ThisWorkbook.Worksheets("Sheet1").Ranges ....Do something.... Next MyRange however, this of course, doesn't work. Any ideas? -- JFamilo ------------------------------------------------------------------------ JFamilo's Profile: http://www.excelforum.com/member.php...o&userid=17276 View this thread: http://www.excelforum.com/showthread...hreadid=396243 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looping through named ranges
Thanks! This really helps! -- JFamilo ------------------------------------------------------------------------ JFamilo's Profile: http://www.excelforum.com/member.php...o&userid=17276 View this thread: http://www.excelforum.com/showthread...hreadid=396243 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) | |||
Deleting named ranges by looping through range collection | Excel Programming | |||
named ranges - changing ranges with month selected | Excel Programming | |||
Looping through named ranges | Excel Programming | |||
looping cells though a named range | Excel Programming |