Re: deleting rows with zero value
From: frayer (frayer.17n0t3_at_excelforum-nospam.com)
Date: 06/10/04
- Next message: Frank Kabel: "Re: Reverse cell value and convert to date"
- Previous message: Mike: "Re: row numbers missing etc"
- In reply to: Frank Kabel: "Re: deleting rows with zero value"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 10 Jun 2004 08:49:53 -0500
Hi Frank, here is the problem because the blank"template" file is loaded
with zero in each cell in C. col. The routine is that each country
colleague fills the items they use, leaving zero in those they don't
use. They should save the file under specific name.xls and at that time
the code will delete the rows with zero in col. C
Should be the normal routine.
BUT, if they save the file BEFORE filling their items, then the code
will find all rows with zero and delete them.
To avoid that, I though about naming the blank file with .xlt (as
template) and your code is only starting when the file is saved under
xls
Is it realistic? Thks
Michel
--- Message posted from http://www.ExcelForum.com/
- Next message: Frank Kabel: "Re: Reverse cell value and convert to date"
- Previous message: Mike: "Re: row numbers missing etc"
- In reply to: Frank Kabel: "Re: deleting rows with zero value"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
