Turning AutoFilter off

[Marcus Gee]

Greetings - I'm working on a macro that will (1) load a customer list (from a QuickBooks export), (2) delete rows and columns that aren't required, (3) delete certain rows conditionally, (4) calculate a date based on customer schedules, and then (5) generate some reports.

Thanks to several folks on this forum the macro is working through step 4 at this point, but my question relates to step 3. I can execute the macro one sub at a time, but each of the conditional delete routines is leaving the autofilter on for some reason, which causes the next sub to delete (erroneously) all other lines except the header line. Any Suggestions? the wrapped code for the macro through step three is included below. Thanks in advance.

Marcus

[Leith Ross]

Hello Marcus Gee,

The code you posted turns the AutoFilter on and off in each routine. Since this problem doesn't appear to be with this code specifically, you post should your workbook. You may have some other code causing the problem.

Sincerely,
Leith Ross

[Marcus Gee]

hey leith - that's what i thought, but i've tried this a number of different ways and always get one of two results.

if i open the application (excel), alt-f11, and then paste the macro code into book1 or into my personal workbook, when i execute the entire macro posted earlier i find all rows but the header row deleted, and with the autofilter arrow showing on the hidden column, or i get a a run time error 1004.

thanks for your help - marcus