Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi All,
This is from Help in VB mode Worksheets("Sheet1").Range("A1").AutoFilter _ field:=1, _ Criteria1:="Otis" VisibleDropDown:=False The last line "VisibleDropDown:=False" is rejected and shows in red in the VB window. When run (as would be expected) it gives a runtime error. Is this a Microsoft error in Help? Can the visible dropdown be hidden? I have got round it by using Advanced Filter but I'm curious. Any feedback would be much appreciated. I have never found an error in Help in VB mode or spreadsheet mode before. Windows XP Pro Office XP Pro Regards, Alan. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel 2007 autofilter change to 2003 autofilter functionality? | Excel Discussion (Misc queries) | |||
2007 excel autofilter back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 excel autofilter change back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 Autofilter worse than 2003 Autofilter | Excel Discussion (Misc queries) | |||
How to Sort within AutoFilter with Protection on (and AutoFilter . | Excel Discussion (Misc queries) |