Named Range - looping through each cell

Dear all, I have a named range TEST (B2:C3 and C5:D6) and I would like in VB loop though each cell in that range recording it's value whether it is a formula or value. I can dot hat with the following code but it requires cell's co-ordinates whereas in named range we have 2 sets of ranges and name is explicit.

Please Login or Register  to view this content.

thanks a lot!

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here