select cell rather selecting entire row
 

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

select cell rather selecting entire row
 

Just take out Entirerow.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"ilyaskazi" wrote
in message ...

With my criteria i am selecting here entire rows after doing after
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 With
--------------------

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


--
ilyaskazi
------------------------------------------------------------------------
ilyaskazi's Profile:
http://www.excelforum.com/member.php...o&userid=23969
View this thread: http://www.excelforum.com/showthread...hreadid=488159