Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
A macro that copies and pastes autofiltered cells will fail.
Take a spreadsheet with data. Start recording a macro. Autofilter some of
the cells. Copy all of the cells of the spreadsheet. Paste the cells into an empty spreadsheet. Go back to the first spreadsheet and turn off autofilter. Turn off the macro. Delete the contents of the second spreadsheet. Go back to the first spreadsheet and try to run the macro. The macro will run but the second spreadsheet will not be filled. The command, "ActiveSheet.paste" will not be present in the macro. If you add the command. the macro will halt with a 1004 error. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
A macro that copies and pastes autofiltered cells will fail.
Does not sound right to me? It works in Excel 2002 SR-2 -- Cheers Nigel "Mafunzalo" wrote in message ... Take a spreadsheet with data. Start recording a macro. Autofilter some of the cells. Copy all of the cells of the spreadsheet. Paste the cells into an empty spreadsheet. Go back to the first spreadsheet and turn off autofilter. Turn off the macro. Delete the contents of the second spreadsheet. Go back to the first spreadsheet and try to run the macro. The macro will run but the second spreadsheet will not be filled. The command, "ActiveSheet.paste" will not be present in the macro. If you add the command. the macro will halt with a 1004 error. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
A macro that copies and pastes autofiltered cells will fail.
It worked in my Excel 2002, too. The error showed when I upgraded to 2003.
"Nigel" wrote: Does not sound right to me? It works in Excel 2002 SR-2 -- Cheers Nigel "Mafunzalo" wrote in message ... Take a spreadsheet with data. Start recording a macro. Autofilter some of the cells. Copy all of the cells of the spreadsheet. Paste the cells into an empty spreadsheet. Go back to the first spreadsheet and turn off autofilter. Turn off the macro. Delete the contents of the second spreadsheet. Go back to the first spreadsheet and try to run the macro. The macro will run but the second spreadsheet will not be filled. The command, "ActiveSheet.paste" will not be present in the macro. If you add the command. the macro will halt with a 1004 error. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
command button that copies and pastes from one list box to another | Excel Discussion (Misc queries) | |||
Some formulas don't track copies, pastes, fill right, fill down | Excel Discussion (Misc queries) | |||
A Macro that Copies from Excel & Pastes into a webpage | Excel Discussion (Misc queries) | |||
Copies 02/22/2005, Pastes 02/21/2001 | Excel Worksheet Functions | |||
change a macro so that it copies and pastes data as values rather than references | Excel Programming |