Autofilter run time error 400

R

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error 1004 on Range.Text with AutoFilter 3
Eliminate blanks while copy row and transpose 11
Autofilter problem 9
Filtering/Excluding Values 1
Autofilter based on user inputbox 3
Select method failed - Error 400 2
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Excel 2003 autofiltering options from a userform 0

Top