xl2002 problem

[Gary Keramidas]

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.

 

[Tim]

Try
Application.cutcopymode=false

after the copy operation.

Tim

 

[Gary Keramidas]

i have that in here already

--


Gary

Try
Application.cutcopymode=false

after the copy operation.

Tim

 

[Gary Keramidas]

i found the problem, it wasn't the line of the copy, it was the subsequent
pastespecial line. i moved the application displayalerts=false and the macro
just went to the error handler routine without pasting anything. so i removed it
completely and found that they created their master sheets with MERGED CELLS
and it threw and error when it tried to paste the values.