I saw the following from an earlier post:

Dim nm As Name
For Each nm In ThisWorkbook.Worksheets(5).Names
MsgBox nm.Name
Next nm

This is what I would like to do - loop through all the ranges on a given
page, and then do something.

However, the above does not seem to work. It only show the "Print Area"
range, then the for next statement quits.

Any thoughts as to why it doesn't show ALL the ranges on Worksheet(5),
because there are about 50 of them on my spreadsheet.

Thanks for all help.
--
Craig