That's actually one logical line split over two physical lines:

allbk.activesheet.CurrentRegion.copy _
destination:=overbk.Sheets("Means").Range("C5")

The space underscore means that the line is continued.

wrote:
<<snipped
Thanks for the above, but when I try to run the above I get this line
highlighted in yellow
allbk.ActiveSheet.CurrentRegion.Copy

and a pop-up thats says compile erro: Syntax error for this line
Destination:=overbk.Sheets("Means").Range("C5")

Any thoughts?

--

Dave Peterson