View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Autofilter run time error 400

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!