Selecting Cells

[Terry]

Hello another question for the excel guru's, again thanks in advance for your
help.

I have a list of values in column Q, I have a formula that identifies values
which I am interested in selecting.(The row is identified when column Q has
the text "Sums to ")

I need a macro which will select only the identifed rows so i can then
copy,delete or move them.

Thanks,

Terry

 

[Don Guillett]

Have a look in the vba help index for FINDNEXT.
OR,
use data>filter>autofilter>filter on col q