Updating a datasheet without all the blinking

  • Thread starter Thread starter aine_canby
  • Start date Start date
A

aine_canby

Hi there,

Using Updating a wroksheet in Excel. Is there a way to freeze the
worksheet so that all the updates are only presented once they have
been completed.

Thanks,

Aine.
 
Application.ScreenUpdating = False
do your thing
Application.ScreenUpdating = True
 
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

make worksheet tab blink? 1
macro changes sheet location 2
Adding 4 cells next to eachother and then adding the following fourcells 3
Delay update of sheets 2
Unlocked Region within Worksheet 1
Excel Referencing one cell from a different worksheet and slide in powerpoint 0
SCAN.CO - £5,300 Gone. No PC. No Answers. One of the Worst Companies Ive Ever Dealt With. 3
VBA Excel - Select a value from one cell in Excel to update a SQL table 1

Back
Top