I have the following bit of code

Set newWS =
myWS.Copy(After:=CombinedWB.Sheet(CombinedWB.Works heets.Count))

newWS and myWS are worksheets and CombinedWB is a workbook.

I'm getting a compile error (Expected Function or Variable) on COPY. What
am I missing? I've done this before and can't find the example.

Thanks,

Barb Reinhardt