View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Radon Radon is offline
external usenet poster
 
Posts: 6
Default Autofilter run time error 400

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!