pasteall problem
 

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?

--


Gary Keramidas
Excel 2003

pasteall problem
 

Don't know for su

Check he

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


"Gary Keramidas" <GKeramidasAtMSN.com wrote in message
...
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?

--


Gary Keramidas
Excel 2003

pasteall problem
 

That is the wrong reference. Disregard.


"Gary Keramidas" <GKeramidasAtMSN.com wrote in message
...
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?

--


Gary Keramidas
Excel 2003

pasteall problem
 

This is the right one:

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


"Gary Keramidas" <GKeramidasAtMSN.com wrote in message
...
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?

--


Gary Keramidas
Excel 2003