With my criteria i am selecting here entire rows after doing afte
autofilter like this:


Code
-------------------
With ActiveSheet
If .AutoFilterMode = False Then .Cells(1, 1).AutoFilter
.Range("A1").AutoFilter Field:=4, Criteria1:="ZONE 3"
'.Range("A1").CurrentRegion.Offset(1, 0).SpecialCells _
(xlCellTypeVisible).EntireRow.Select
.AutoFilterMode = False

End Wit
-------------------

....instead i need to select only cells of my Criteria field

--
ilyaskaz
-----------------------------------------------------------------------
ilyaskazi's Profile: http://www.excelforum.com/member.php...fo&userid=2396
View this thread: http://www.excelforum.com/showthread.php?threadid=48815