Iterate through the values in a named range?

B

Brian

How do I iterate through the values in a named range? In the code below 'nameChannels' is a named range in my file

Bria

Sub Extract_Paf_Forms(

myName = Array(nameChannels

For Each a In myNam
MsgBox (a
Next

End Sub
 
V

Vasant Nanavati

Dim c As Range
For Each c In Range("nameChannels")
MsgBox c.Value
Next

--

Vasant

Brian said:
How do I iterate through the values in a named range? In the code below
'nameChannels' is a named range in my file.
 
Top