Re: deleting negative numbers

Tech-Archive recommends: Speed Up your PC by fixing your registry

The former is correct, and the first negative number appears in column I
(eye). Also, when I try to call a second macro, the directions somehow
"lose" their way, and fill in data in columns to the right of the regular
data. How can I regulate that? The reason is I want the macros to run in
sequence, transparent to the user. Thanks again.
--
Burt


"Rick Rothstein (MVP - VB)" wrote:

Do you want to delete the row if any cell in the row is negative or only if
all the cells in the row are negative? If the former, is there one
particular column that goes negative before any of the others do (if so,
that will make for more efficient code)?

Rick

"BurtArkin" <BurtArkin@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E6D8172E-95FD-4BA5-8C6B-CC50C0D5A810@xxxxxxxxxxxxxxxx
I have an amortization table where the numbers eventually turn negatve.
How
can I find the negative numbers and delete all rows where a negative
number
appears? Thanks for your anticipated response.
--
Burt


.