ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Silence cell movment during processing... (https://www.excelbanter.com/excel-programming/297239-silence-cell-movment-during-processing.html)

ppsza[_5_]

Silence cell movment during processing...
 
Hi,

I'm looking for a way to keep the spreadsheet cell from zipping aroun
all over the screen when my code processes. Anyone know of a way to d
this?

Thanks

--
Message posted from http://www.ExcelForum.com


pikus

Silence cell movment during processing...
 
If I'm understanding your question, put:

Application.ScreenUpdating = False

At the top of your code and:

Application.ScreenUpdating = True

at the end. - Piku

--
Message posted from http://www.ExcelForum.com



All times are GMT +1. The time now is 08:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com