nu heb ik 3 acties nodig:
Worksheets("sheet1").Range("A1").Copy _
Destination:=Worksheets("sheet2").Range("d3")
Worksheets("containers").Range("A1").Copy _
Destination:=Worksheets("sheet3").Range("d3")
Worksheets("containers").Range("A1").Copy _
Destination:=Worksheets("sheet4").Range("d3")
Is dit te combineren in 1 regel ? b.v. (geeft foutmelding)
Worksheets("sheet1").Range("A1").Copy _
Destination:=Worksheets("sheet2").Range("d3") =Worksheets("sheet3").Range("d3") =Worksheets("sheet4").Range("d3")
bedankt vast
groet rop
Worksheets("sheet1").Range("A1").Copy _
Destination:=Worksheets("sheet2").Range("d3")
Worksheets("containers").Range("A1").Copy _
Destination:=Worksheets("sheet3").Range("d3")
Worksheets("containers").Range("A1").Copy _
Destination:=Worksheets("sheet4").Range("d3")
Is dit te combineren in 1 regel ? b.v. (geeft foutmelding)
Worksheets("sheet1").Range("A1").Copy _
Destination:=Worksheets("sheet2").Range("d3") =Worksheets("sheet3").Range("d3") =Worksheets("sheet4").Range("d3")
bedankt vast
groet rop