Cycle through named range

[C0nfus3d]

Really stuck and have been all over the net looking for help. I have a named range with 30 locations listed, I just want to know how to take each name from this range, enter it into a fixed cell, perform some actions then repeat for the next name in the range. Many thanks!

 

[VoG]

Try like this

Dim c As Range
For Each c In Range("MyRange")
    Range("A1").Value = c.Value
    '
    'more code
    '
Next c

 

[C0nfus3d]

I think that will do it, thanks, you're a life saver!!!