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?