View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Vasant Nanavati Vasant Nanavati is offline
external usenet poster
 
Posts: 1,080
Default 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