Hi,
I have the following macro who now return a runtime error 1004, paste method of worksheet class failed.
I don't know how to change it to make it work. Any help ?
Sub Paste_TOP()
Sheets("Details TOP per month").Select
Cells.Select
Range("C1").Activate
Selection.EntireColumn.Hidden = False 'Unhide all columns
NextRow = Range("C65536").End(xlUp).Row + 1
Cells(NextRow, 1).Select 'select next free row
ActiveSheet.Paste
Application.CutCopyMode = False
End Sub
I have the following macro who now return a runtime error 1004, paste method of worksheet class failed.
I don't know how to change it to make it work. Any help ?
Sub Paste_TOP()
Sheets("Details TOP per month").Select
Cells.Select
Range("C1").Activate
Selection.EntireColumn.Hidden = False 'Unhide all columns
NextRow = Range("C65536").End(xlUp).Row + 1
Cells(NextRow, 1).Select 'select next free row
ActiveSheet.Paste
Application.CutCopyMode = False
End Sub