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
|