Iterate through the values in a named range?
 

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

Iterate through the values in a named range?
 

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

--

Vasant

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

Brian

Sub Extract_Paf_Forms()

myName = Array(nameChannels)

For Each a In myName
MsgBox (a)
Next a

End Sub