Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Based on Values in Named Range Q | Excel Worksheet Functions | |||
Countif and values greater than zero for a named range | Excel Worksheet Functions | |||
Sum values in columns based on values in named range | Excel Worksheet Functions | |||
Named range not continuous. How to display values? | Excel Worksheet Functions | |||
Named range changes values | Excel Discussion (Misc queries) |