Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
For Next loop
Kevin,
Dim Nam as Name For each Nam in Activesheet.Names 'yak yak yak Next Nam hth, Doug "Kevin" wrote in message ... I want to perform certain tasks for each name in the activeworksheet. I'm not sure how to write the loop. For Each Name in Activesheet blah blah Next This doesnt work, what would be the correct syntax? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
For Next loop
What exactly are you trying to do?
The reason it doesn't go into the loop is because there are no names in that worksheet. If you let the group know why you want to do that loop, then the group can tell you how to do it. Cheers, Jason Lepack Doug Glancy wrote: Kevin, Dim Nam as Name For each Nam in Activesheet.Names 'yak yak yak Next Nam hth, Doug "Kevin" wrote in message ... I want to perform certain tasks for each name in the activeworksheet. I'm not sure how to write the loop. For Each Name in Activesheet blah blah Next This doesnt work, what would be the correct syntax? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
For Each ... Next loop - need to reference the loop variable | Excel Programming | |||
Advancing outer Loop Based on criteria of inner loop | Excel Programming | |||
Loop Function unable to loop | Excel Programming | |||
Problem adding charts using Do-Loop Until loop | Excel Programming | |||
HELP!!!! Can't stop a loop (NOT an infinite loop) | Excel Programming |