View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Deleting a row with a cell containing a value of 0.00

Have you tried DataFilterAutofilter for 0.00 and deleting the resultant
rows?


Gord Dibben MS Excel MVP

On Fri, 12 Dec 2008 14:49:03 -0800, RW wrote:

I would like to delete all the rows in a worksheet that contain the value of
0.00, these values come from another worksheet through the formula
=CheckInfo!$AC$2. The 0.00 are all in the same column. I am using Excell 2003.