OK,

Here is what I am trying to accomplish: I have a large worksheet I am
working with and I am working on a macro to select certain cells that
meet a specific criteria and copy and paste those cells only into
another worksheet. I have the select and paste part down but how to I
enable it to assign a condition? For example, I would like the macro
to select all the cells that contain 99 in the front of the number of
one column and copy those cells into another worksheet. Can someone
please point me in the right direction? Thanks in advance.

-Dave


--
DSC174
------------------------------------------------------------------------
DSC174's Profile: http://www.excelforum.com/member.php...o&userid=27553
View this thread: http://www.excelforum.com/showthread...hreadid=470759