Silence cell movment during processing...

  • Thread starter Thread starter ppsza
  • Start date Start date
P

ppsza

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
 
If I'm understanding your question, put:

Application.ScreenUpdating = False

At the top of your code and:

Application.ScreenUpdating = True

at the end. - Piku
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

can't move UserForm with the mouse 2
Newbie Needs Help. 2
processing time (revised and re-posted) 10
Copy excel cell to webform (search box) and press enter 10
PC Power & Cooling Silencer MK III 750W 0
How much memory does VBA code occupy? 6
SCAN.CO - £5,300 Gone. No PC. No Answers. One of the Worst Companies Ive Ever Dealt With. 3
Move multiple values in single Cell To Cells of there own? 3

Back
Top