Autofilter run time error 400

's Computer Specifications

Hello! When I run the code below, I can see the first row being selected and
the autofilter being turned on. However, I'm getting a run time error 400.
Any ideas?

'Set autofilter on
If Not oSheet.AutoFilterMode Then
oSheet.Rows("1:1").Select
Selection.AutoFilter = True
End If

Thanks!

's Computer Specifications

Dear Radon

'Selection.AutoFilter' is enough

If this post helps click Yes
---------------
Jacob Skaria

"Radon" wrote:

> Hello! When I run the code below, I can see the first row being selected and
> the autofilter being turned on. However, I'm getting a run time error 400.
> Any ideas?
>
> 'Set autofilter on
> If Not oSheet.AutoFilterMode Then
> oSheet.Rows("1:1").Select
> Selection.AutoFilter = True
> End If
>
> Thanks!

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
excel 2007 autofilter change to 2003 autofilter functionality?	jonnybrovo815	Microsoft Excel Misc	1	19th Apr 2010 10:05 PM
2007 excel autofilter back to 2003 autofilter?	jonnybrovo815	Microsoft Excel Misc	3	19th Apr 2010 08:11 PM
2007 excel autofilter change back to 2003 autofilter?	jonnybrovo815	Microsoft Excel Misc	1	19th Apr 2010 05:53 PM
Autofilter rows and columns at the same time	=?Utf-8?B?ZXhjZWwgZnJhbWVz?=	Microsoft Excel Programming	0	9th Aug 2006 10:05 PM
An autofilter that can filter arrays of time	Powerkor	Microsoft Excel Worksheet Functions	1	8th Nov 2003 01:15 PM