I'm trying to run a macro but I'm getting the following error message:
Run-time error 1004 paste method of worksheet class failed
When I click debug on the error message window ActiveSheet.Paste is highlighted yellow. Can someone tell me what I may be doing wrong?
![]()
Selection.NumberFormat = "#,##0.00_);[Red](#,##0.00)" Range("H1").Select ActiveSheet.Paste Columns("I:I").EntireColumn.AutoFit Columns("J:J").EntireColumn.AutoFit
Bookmarks