I'm getting an error 'Expected =' and I'm not sure why.
This is the line it didn't like.
Sheets(1).copy(after:=Workbooks("Report").Worksheets(Workbooks("Report").Worksheets.Count))
I'm trying to copy a sheet to a different wordbook. Any help with the error would be appreciated. Thanks