Scott,

A little difficult to be specific without seeing the code. But let us assume
that you have found the row and that is stored in a row number variable of
cRow, then delete that row with

Cells(cRow,1).Entirerow.Delete

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Scott Whetsell, A.S. - WVSP"
wrote in message
...
Hello.

I have a program in excel that we are using to track our protective
orders.
I have the information broken into two worksheets, one for active orders
and
one for expired orders. The general user of this program will never see
the
actual worksheets because of userforms that are made for them to work
with.
My question is this:

I have a script written now that will search the active list for any
records
that indicate that they are expired or have been terminated. It does this
by
looking at column "X" to determine if the record itself is a test record,
and
if it is not, it look at column "C" to get the value from the formula
("VALID", "INVALID", "EXPIRED", "TERMINATED"). Those values are
determined
by a legnthly formula that references about 8 other columns in the record
to
validate it. When the script finds one matching either "EXPIRED" or
"TERMINATED" it copies the entire row to the second worksheet and certain
information to a third worksheet to printout for manual updating of the
hard
copies. The problem I am having is that I cannot get it to delete the
record
after it has copied it to the other sheets. How can I get excel to
delete
the records off of Sheet1 after it has been moved to Sheet2?

Any help would greatly be appreciated.