AutoFilter

[Alan]

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.

 

[Rob Bovey]

Hi Alan,

That line of code is just missing a comma and a line continuation
character. Here's a corrected version:

Worksheets("Sheet1").Range("A1").AutoFilter _
field:=1, _
Criteria1:="Otis", _
VisibleDropDown:=False

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm

 

[Alan]

Thanks Rob,
Cant believe I didn't spot that! Blind faith in Help I suppose,
Regards,
Alan.