Got an error with the following
Worksheets("mod").Range("c1:g1").copy _
Destination:=Worksheets("mix").Cells(1, 9)

If the error is subscript out of range, then either you don't have a sheet
named mod or you don't have a sheet named mix or you have neither. Assumes
neither sheet is protected.

--
Regards,
Tom Ogilvy

"crapit" wrote in message
...
Got an error with the following
Worksheets("mod").Range("c1:g1").copy _
Destination:=Worksheets("mix").Cells(1, 9)

also:
OP is not using qualified references, thus be aware that the code
(attempts) to work with the active workbook.


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Tom Ogilvy wrote :

If the error is subscript out of range, then either you don't have a
sheet named mod or you don't have a sheet named mix or you have
neither. Assumes neither sheet is protected.

So can i say that the code is correct?
"keepITcool" wrote in message
ft.com...

also:
OP is not using qualified references, thus be aware that the code
(attempts) to work with the active workbook.


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Tom Ogilvy wrote :

If the error is subscript out of range, then either you don't have a
sheet named mod or you don't have a sheet named mix or you have
neither. Assumes neither sheet is protected.