pasteall problem

[Gary Keramidas]

i am wondering if anyone has experienced this issue with pasteall.

i have some pretty basic code that filters some data, copies the visible rows
using specialcells(xlcelltypevisible) and pastes them to another workbook.

problem is, when the filtered rows are not consecutive, it debugs on the
pasteall code, even though the data has already been pasted correctly.

this happens in excel 2003 prior to sp3. once sp3 is installed, the code runs
fine.

anyone know if there was a change/fix in sp3 related to this?

 

[JLGWhiz]

Don't know for sure:

Check here:

http://support.microsoft.com/kb/923648

 

[JLGWhiz]

That is the wrong reference. Disregard.

 

[JLGWhiz]

This is the right one:

http://support.microsoft.com/kb/938790/