Hi everybody, I just created this macro to copy and paste generated data that fluctuates a lot, but it just doesn't work very good...
Every time i activate it, i get a paste error and i get infinite zeros after the data, any suggestions on this one?
Sub Macro1()
Application.ScreenUpdating = False
'IO
Sheets("Hulp_IO").Select
Range("A1").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
Sheets("IO").Select
Range("B2").Select
On Error Resume Next
ActiveSheet.Paste Link:=True
On Error GoTo 0
Range("B2").Select
'Modbus_Lees_Tags_PMSX
Sheets("Hulp_Modbus_PMSX_Lees_Tags").Select
Range("A1").Select
Range(Selection, Selection.End(xlDown)).Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Modbus_Lees_Tags_PMSX").Select
Range("D2").Select
On Error Resume Next
ActiveSheet.Paste Link:=True
On Error GoTo 0
Range("D2").Select
'Modbus_Schrijf_Tags_PMSX
Sheets("Hulp_Modbus_PMSX_Schrijf_Tags").Select
Range("A1").Select
Range(Selection, Selection.End(xlDown)).Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Modbus_Schrijf_Tags_PMSX").Select
Range("D2").Select
On Error Resume Next
ActiveSheet.Paste Link:=True
On Error GoTo 0
Range("D2").Select
'Modbus_Lees_Tags_PackScan
Sheets("Hulp_Modbus_Pakscan_Lees_Tags").Select
Range("A1").Select
Range(Selection, Selection.End(xlDown)).Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Modbus_Lees_Tags_PackScan").Select
Range("A2").Select
On Error Resume Next
ActiveSheet.Paste Link:=True
On Error GoTo 0
Range("A2").Select
'Modbus_Schrijf_Tags_PackScan
Sheets("Hulp_Modbus_Pakscan_Schrijf_Tag").Select
Range("A1").Select
Range(Selection, Selection.End(xlDown)).Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Modbus_Schrijf_Tags_PackScan").Select
Range("A2").Select
On Error Resume Next
ActiveSheet.Paste Link:=True
On Error GoTo 0
Range("A2").Select
Sheets("Start").Select
End Sub
Bookmarks