Autofilter run time error 400

[Radon]

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!

 

[Jacob Skaria]

Dear Radon

'Selection.AutoFilter' is enough

If this post helps click Yes