Hi Frank, here is the problem because the blank"template" file is loade
with zero in each cell in C. col. The routine is that each countr
colleague fills the items they use, leaving zero in those they don'
use. They should save the file under specific name.xls and at that tim
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 cod
will find all rows with zero and delete them.
To avoid that, I though about naming the blank file with .xlt (a
template) and your code is only starting when the file is saved unde
.xls
Is it realistic? Thks
Miche

--
Message posted from http://www.ExcelForum.com