I have two columns in excel.All numbers.

column A ---1,2,3,4,5,6,7,8,9,
column B ---123,0,654,0,23,55,0,0,0

I want the macro to do the following
======================================
Start with column B.If it finds 0 in some row in column B, delete th
row itself in excel.so after runnning the
macro the above data will look as follows.


Output of the macro
=====================
column A ---1,3,5,6
column B ---123,654,23,55

Important: I do this everytime I open an excel spread sheet.Forma
cells--Category--Number--
---4 Decimal Places.


Thank-You for all the help.


excelgur

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