| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Colon at the end of excel file name(ex: problem.xls:1, problem.xls | New Users to Excel | |||
| Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
| problem with a conditional max problem | Excel Discussion (Misc queries) | |||
| Problem when multipple users access shared xl-file at the same time, macrocode for solve this problem? | Excel Programming | |||
Hybrid Mode
