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