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