Error Expected =

[Jetx227]

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

 

[Fluff]

Try
Sheets(1).copy after:=Workbooks("Report").Worksheets(Workbooks("Report").Worksheets.Count)

 

[Jetx227]

Try
Sheets(1).copy after:=Workbooks("Report").Worksheets(Workbooks("Report").Worksheets.Count)

Worked, Thanks!

 

[Fluff]

You're welcome & thanks for the feedback