Why not use the Autofilter to simply filter on the 'Out of Range' message in
col D?
HTH,
--
Gary Brown

If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"jantoni" wrote:

I need to have a group of cells be copied to another sheet when a cell
returns a certain text message. IE - if cell d25 shows" out of range", then
copy cells a25:c25 to another sheet?

I think I need something like an exception report. When the worksheet is
opened it gathers data and then displays when it is out of range. I need to
get only the rows that are out of range to appear in a different sheet so I
don't have to scroll thru a bunch of rows to fine any that went out of range.

I hope this has made sense...THX