You're right. Can your process support using the ENTER button to force the change? In other words, can you place the cursor on A1 and hold down the enter button until all cells are cycled through. Sorry, I have to think on this some more to give you the desired solution. Would a single update button better meet your needs?