Printing From Macro Without Jumping Around

Good afternoon,

I have a spreadsheet that I use a button attached to a macro to print 12 pages of data from various areas of the spreadsheet.

Years ago when I worked with Lotus 1-2-3, there was a feature that allowed printing to occur in the background without the screen jumping all over the spreadsheet while printing. Can Excel do this as well? Does this make sense?

Hello RickT,

In your code use Application.ScreenUpdating = False to prevent the "jumping" and then when the printing is done, turn it back on with Application.ScreenUpdating = True

Sincerely,
Leith Ross