Thank you, Don

Got an immediate syntax error with your efforts.

I didn't mention that I'm using Excel 2003, VBA 2005, if that makes a
difference.

I've only been at this for a month with VBA.
Two books, 1000 pages each aren't much help for a beginner.

I have written code for 4 other procedures that work fine, a total of
about 3000 lines of code. 1 runs 2-3 seconds, 1 for 8 seconds, one for
15 seconds, 1 in a couple seconds.  About a 2 day job manually.

My present one is nested loops which work, until I get to clearing
data where zero balance value is in  the current row/cell address.
Sure seems like a it should be a simple procedure to me.  This should
run about 5-8 seconds or so.

Of all the examples I've seen, nothing addresses this.  Gosh, this is
a common procedure in cleaning obsolete data in an Inventory Control
file at EOM.

I have a rather complicated Master Excel file as it involves two
currencies with conversions, and all financial info, with two
inexperienced users.  Can't use a common template.
This file has extra rows for data entry, so I'm trying to avoid a
procedure that performs a routine on empty rows, thus my use of data
count in each sheet.  Do not want to delete empty rows.

Thanks a bunch.  I'll keep on keepin' on.

Ed ..ejione@sbcglobal.net