Home |
Search |
Today's Posts |
#1
|
|||
|
|||
copy and paste with 2 different workbooks problem
Hi, can anyone simplyfy this code as it is used in the workbook open event
but it blinks 4 times because the following code although it does the job i think i ask for to many activate on the payslip side as that is the book that when opens seems to perorm 4 operation, hense the movement, any ideas please Workbooks("Staff Details").Activate Range("I4:I10").Select Selection.Copy Worksheets("Payslip").Activate Range("B2:B8").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Workbooks("Staff Details").Activate Range("C4").Select Selection.Copy Worksheets("Payslip").Activate Range("C11").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Workbooks("Staff Details").Activate Range("C9").Select Selection.Copy Worksheets("Payslip").Activate Range("K11").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Workbooks("Staff Details").Activate Range("G9").Select Selection.Copy Worksheets("Payslip").Activate Range("K12").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False -- BD3 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
Copy and paste between workbooks | Excel Discussion (Misc queries) | |||
How do I create a formula to copy and paste between workbooks? | Excel Discussion (Misc queries) | |||
Can't Copy and Paste between Excel 2003 Workbooks | Excel Discussion (Misc queries) | |||
cannot copy and paste worksheets or workbooks | Excel Discussion (Misc queries) |