macros over different sheets

R

Robb.rich

can you keep the current sheet viewable whilst a macro updates or copies from
another sheet, when i try this the screen jumps.
 
G

Gary''s Student

Application.ScreenUpdating = False
do_some_sutff
Application.ScreenUpdating = True
 

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

Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Combining two sheets of data into one and sorting by value - using macros 5
External cell reference between two excel worksheets both in One Drive 0
Drop down list control value in vba 2
Bugs in Office 2019 0
downloading a template into a new sheet of an existing workbook 1
Macro to copy table of contents to a new doc 0
Consolidation Table from Different Excel Tabs with Different Format 1

Top