| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
autofilter raises error 1004
Hi,
I want an AutoFilter over a couple of columns. So I did this: Sub af() Dim ws As Worksheet Set ws = ThisWorkbook.Worksheets(1) ' Instead 1 "Sheet1" also ws.Range("A1:D1").AutoFilter field:=1, Criteria1:="", VisibleDropDown:=False End Sub Even a macro record didn't work as expected. Excel Version is 2k3 SP3 THX 4 Help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error when cell A1 is not active and xlInsideVertical border formatthrowing error 1004 | Excel Programming | |||
| Macro runtime error 1004 with Autofilter | Excel Discussion (Misc queries) | |||
| Mysterious Error 1004 caused by AutoFilter? | Excel Programming | |||
| Error 1004 update autofilter and pivottable | Excel Programming | |||
| ClearContents in event proc raises error | Excel Programming | |||
Threaded Mode
