Most valuable professional
  • 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:

  • Excel
  • Microsoft Excel