| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced autofilter not working in macro
I am using the follwoing code to filter data greater than certain date. But
unfortunately all data gets hide when I run the macro. However when I open and close the autofilet after Macro has run, proper values are visible. please help me out... Date = Cells(erow - 49, 4) Sheets("data").Select Range("a6").Select Selection.AutoFilter Range("O6").Select Selection.AutoFilter Field:=15, Criteria1:="=" & Date |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro with custom autofilter for greater and less than specific da | Excel Discussion (Misc queries) | |||
| error when running cut & paste macro | Excel Worksheet Functions | |||
| Advanced Filter not working | Excel Worksheet Functions | |||
| Keyboard shortcut not working when I copy macro to another computer | New Users to Excel | |||
| Macro Help In Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
