I am fairly new user of Visual Basic. I am trying to find a way to loop using a value in a range name to end loop, but have been unsuccessful so far. The range name will change when we process a new day, but would not change within the loop. I have tried a Do While Range("work") = Range("day") & =day & = "day" . The answer is proably simple but it is beyond my knowledge.

Sandy, if could you give us a simple description of what you are trying to
do I am certain that many of us can leap in and help. Unfortunately, the
meaning/purpose of Do While Range("work") = Range("day") & =day & = "day"
escapes me, so I am left being unable to help.

Some things to look at doing is checking a value in a cell and if it is out
of range then to exit:

For each cell in Range("work")
if cell.value somevalue then exit for
'do some work
Next

Again, when we understand more, we can help more.

Bob Flanagan
Macro Systems
Delaware, U.S. 302-234-9857
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"sandyc" wrote in message
...
I am fairly new user of Visual Basic. I am trying to find a way to loop
using a value in a range name to end loop, but have been unsuccessful so
far. The range name will change when we process a new day, but would not
change within the loop. I have tried a Do While Range("work") =
Range("day") & =day & = "day" . The answer is proably simple but it is
beyond my knowledge.