Selecting Cells
 

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

Selecting Cells
 

Have a look in the vba help index for FINDNEXT.
OR,
use datafilterautofilterfilter on col q

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Terry" wrote in message
...
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