As far as I know, though, you can't just show a single cell updating in the presence of other changes on the same sheet.
You could generate a temporary worksheet for display purposes, but if you're working with a lot of data, this is probably not a viable option. However, I do switch sheets twice, which is a big reason for me to turn off screen updating.
It will automatically turn onwhen the macro is finished.
How can you turn off the flashing screen during macro execution ?
The example hides every other column on Sheet1, while keeping track of the time it takes to do so.
The first time the example hides the columns, screen updating is turned on; the second time, screen updating is turned off. Hidden = True End If Next c stop Time = Time elapsed Time(i) = (stop Time - start Time) * 24 * 60 * 60 Next i Application.
I used this function about 7 years ago and it prevented the user from seeing a bunch of activity while the macro ran.
It essentially freezes the screen until the code is fully executed.