Flicking

[spog00]

Hi All,
Is there any way to prevent macros from showing you what they're doing? I've got a paste macro and it keeps flicking down as it pastes the data into the new part of the sheet. Can I freeze the current sceen while it runs? Or anything, Please help

Cheers

This is the problem bit:

Sheets("inputsFormat").Range("h518:r867").Copy

Sheets("inputs").Range("h518:r867").PasteSpecial Paste:=xlValues, Operation:=xlMultiply, SkipBlanks:= _
True, Transpose:=False
Application.CutCopyMode = False

[theDude]

Use the following:

Please Login or Register  to view this content.

Hope this helps!
theDude

[spog00]

Works like a dream, thanks!