Team,
I have tried debugging the below code and cannot find any issue, but it keeps failing with a 1004 error: Paste method of worksheet class failed.
The code works until it gets to the "ActiveSheet.Paste Destination:=Worksheets("Sheet1").Range("B2:B500") ' works with column B" line. Then...