| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter turn off with macro
Many thanks
"Gary''s Student" wrote: AutoFilter toggles; so just add another: Range("A14:j65536").Select Selection.AutoFilter at the end -- Gary''s Student - gsnu200848 "Shaggyjh" wrote: Another macro question about the autofilter! I have a macro as below that filters my worksheet to only show rows where there is a value in column C and outputs it to the print preview screen. When you close the preview screen the print range is selected and the filter is still on. Is there anyway of editing the macro so that when you close the print preview screen the worksheet has no selection or filter? The Macro: Sub setprintarea() Range("A14:j65536").Select Selection.AutoFilter Selection.AutoFilter Field:=3, Criteria1:="<" Columns("A:j").Select Range("A2").Activate Selection.PrintOut Copies:=1, Preview:=True, Collate:=True End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro turn off AutoFilter | Excel Worksheet Functions | |||
| Turn of Autofilter Arrows? | Excel Programming | |||
| Turn ON Autofilter Filters | Excel Programming | |||
| IF AutoFilter is on, turn it off | Excel Programming | |||
| Turn AutoFilter off by code? | Excel Programming | |||
Threaded Mode
