PDA

View Full Version : Problem with Autofilter



Cass
10-24-2006, 09:49 AM
Hello!
Why i got error 1004 with this code :dunno


Range("A9:K9").AutoFilter Field:=11, Criteria1:="JU"


Earlier it works fine but lately no :think:

It's a part of code but in principle this code filter array items. and copy/paste the result another sheet. any idea?!

Bob Phillips
10-24-2006, 12:01 PM
If ActiveSheet.AutoFilterMode Then
ActiveSheet.Cells.AutoFilter
End If
Range("A9:K9").AutoFilter Field:=11, Criteria1:="JU"