ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   error '438' (https://www.excelbanter.com/excel-programming/339634-error-438-a.html)

ALEX

error '438'
 
I have the error '438' - Object doesn't support this property or method.
Private Sub Worksheet_Activate() ' It's Sheet1
....
With Worksheets("Sheet1")
If Not .AutoFilterMode Then
.Range("A3").AutoFilter
End If
.EnableAutoFilter = True

.Protect Password:="password", _
Contents:=True, UserInterfaceOnly:=True
End With
Selection.AutoFilter Field:=1 ' Here I have an error
....

Can anybody advise what's wrong with this code?
Thanks


All times are GMT +1. The time now is 12:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com