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!
|