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.