Application.Run "Violations_VBA .xls!RefreshTab le"
Sheets("Total") .Select
Sheet1.Range("M 5:P5").Copy Destination:=Ra nge("A65536").E nd(xlUp).Offset (1, 0)
I have the above VBA code to paste to the last row of a table, this works fine but I can't get it to paste special values. I have tried to add the code to paste special values but I keep getting the following error: 'Paste special method of Range class failed'.
What am I doing wrong?
Sheets("Total") .Select
Sheet1.Range("M 5:P5").Copy Destination:=Ra nge("A65536").E nd(xlUp).Offset (1, 0)
I have the above VBA code to paste to the last row of a table, this works fine but I can't get it to paste special values. I have tried to add the code to paste special values but I keep getting the following error: 'Paste special method of Range class failed'.
What am I doing wrong?