Try
Application.cutcopymode=false

after the copy operation.

Tim

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
i only use xl2003, and one of my clients has both xl2002 and xl2003. on the
xl2002 boxes, my code comes up with a message about there being a large
amount of data on the clipboard and the macro halts.

i believe it's this line,
ActiveSheet.Copy
which just copies the current sheet to a new workbook.

since i don't have xl2002 installed, i was wondering if someone could help
me out.

--


Gary