I am new to VBA so on my last project I used a macro to get parts of the code I am using. However, the code causes the screen to flicker back and forth between worksheets as some copying and pasting takes place. Is it possible to turn this flickering off and just have the code "do its thing?"
Below is some of the code I used.
Selection.Copy
Sheets("Template").Select
Range("G2").Select
ActiveSheet.Paste
Sheets("Load").Select
ActiveCell.Offset(0, 2).Range("A1").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Template").Select
ActiveCell.Offset(0, 2).Range("A1").Select
ActiveSheet.Paste
'Copy node and paste.
Sheets("Load").Select
ActiveCell.Offset(0, 1).Range("A1").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Template").Select
ActiveCell.Offset(0, 1).Range("A1").Select
ActiveSheet.Paste
EDIT: I should mention I am using a button to initiate my code.
Bookmarks