Hi Brian,

Use the macro recorder when filtering for 2's (using the autofilter)
selecting the visible cells, & removing the filter (w/o changing th
selection), and then adapt this to fit your needs.

Depending on how you adapt the recorded code for the above actions yo
should be able to remove the "activecell" references & replace the
with "selection.offset...".

If this macro is to be used repeatedly with varying amounts of data,
VBA function that checks on visible filtered rows may be useful, see:
http://www.excelforum.com/showpost.p...34&postcount=3


Hope this helps,
Rob Brockett
NZ
Always learning & the best way to learn is to experience..

--
broro18
-----------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...fo&userid=3006
View this thread: http://www.excelforum.com/showthread.php?threadid=50862