It's almost certainly not as simple as just defining a range variable. The right way to do this is to rewrite the worksheet in terms of functions, and then just call the final function multiple times at the end of the worksheet. That might be a lot of work though. The other way it might be possible is via a kludge using the FRAME variable used for animation. It's a little hard to describe how to do that, so if it's possible go to the Collaboratory (see my reply to your other post) and post the worksheet there. Richard