Iterate through the values in a named range?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top