Greetings,
I'm writing some code that analises data and I have been adviced that it is good practice to minimise the function .Select in macros, especially when i'm just copying and pasting stuff. (as .select will make the screen jump from one sheet to the other and back etc.
but how do I minimise .Select in this example:
Sheets("sheet1").Select
Range("A13").Select
Selection.Copy
Sheets("sheet2").Select
Range("F12").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Many thanks
Michiel
Bookmarks