- Hot Topics
Excel flashing macro
Hi out there. I have this crazy macro that I use. There are ten of them that transfer info from one part of the sheet to another. When I active the macros there is a whole heap of flashing backwards and forwards as it does it?s transfer. Would there be a way of fixing it so it runs a bit smoother? Many thanks Narelle Sub Result_R1() ActiveSheet.Unprotect Password:="" ' Result_R1 Macro Range("M6").Select Selection.Copy Range("AE2").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Range("B28").Select Application.CutCopyMode = False Selection.Copy Range("AF2").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
This question generated 35 answers. To proceed to the answers, click here.
This thread is current as of May 18, 2014.
For more resources for Microsoft Excel:
This article includes the following tags:
- Microsoft Excel