Thread: Creteria Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Trever B Trever B is offline
external usenet poster
 
Posts: 21
Default Creteria Help

Hi,

Thanks in advance

The following code is set for Creteria1 to = "A" how do I make it for A, B
or C

With Worksheets("Panel Details").Range("A1:IV2500")
.AutoFilter Field:=1, Criteria1:="A"
.SpecialCells(xlCellTypeVisible).Copy _
Worksheets("SS A").Cells(1, 1)
.AutoFilter
End With


Thanks again

Trev