If sum = 0, delete row
- From: TJN <TJN@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 26 Jul 2005 09:34:06 -0700
I have a spread*** with amounts that start in column C and goes through
column AE (columns A & B contain an entity number and an entity name). The
number of rows varies, but it is typically about 600 rows of data. This data
begins on row 9. Row 8 contains the column headers and the 1st 7 rows
contain junk that comes over from the program I download this data from. It
can be eliminated if it helps.
Basically I am looking for a macro that steps through each row of data and
if the sum of column C through column AE = zero, I would like the entire row
to be deleted.
Does anybody have any ideas? I feel bad because this is the third time I
have come to this group for help. Each time the solutions have been
terriffic. I keep hoping I can answer a question instead of always asking,
but so far all the questions asked have been above my skill level.
Thanks,
Tim
.
- Follow-Ups:
- Re: If sum = 0, delete row
- From: Tom Ogilvy
- Re: If sum = 0, delete row
- Prev by Date: Re: Dynamically adjusting Vlookup
- Next by Date: Re: resize colums / rows in range
- Previous by thread: Where can I find the Function names in other languages
- Next by thread: Re: If sum = 0, delete row
- Index(es):