Re: $$Excel-Macros$$ Fwd: Delete rows from a Sheet based on value found on previous cell

2010-11-06 Thread Cesar Delanoval
lue, 2, >>> 1) = " " Then >>>If Split(Cells(i, 1), " ")(0) * 1 <= Res Then >>>Res = Split(Cells(i, 1), " ")(0) * 1 >>> Else >>> Cells(i, 1).EntireRow.Delete >>>End If >>&

Re: $$Excel-Macros$$ Fwd: Delete rows from a Sheet based on value found on previous cell

2010-11-06 Thread CAN
            Cells(i, 1).EntireRow.Delete >         End If >     Else >         Cells(i, 1).EntireRow.Delete >     End If > Next i > End Sub > > Regards. > Daniel > > -Message d'origine----- > De : excel-macros@googlegroups.com [mailto:excel-mac...@googl

RE: $$Excel-Macros$$ Fwd: Delete rows from a Sheet based on value found on previous cell

2010-11-06 Thread Daniel
om] De la part de CAN Envoyé : vendredi 5 novembre 2010 19:32 À : excel-macros@googlegroups.com Objet : $$Excel-Macros$$ Fwd: Delete rows from a Sheet based on value found on previous cell I posted this discussion a few days ago and I haven't hear any answers on it. Does anyone can help ? Thank you

Re: $$Excel-Macros$$ Fwd: Delete rows from a Sheet based on value found on previous cell

2010-11-05 Thread ashish koul
can u attach the worksheet On Sat, Nov 6, 2010 at 12:02 AM, CAN wrote: > I posted this discussion a few days ago and I haven't hear any answers > on it. Does anyone can help ? > > Thank you > > > -- Forwarded message -- > From: CAN > Date: Nov 3, 10:58 am > Sub

$$Excel-Macros$$ Fwd: Delete rows from a Sheet based on value found on previous cell

2010-11-05 Thread CAN
I posted this discussion a few days ago and I haven't hear any answers on it. Does anyone can help ? Thank you -- Forwarded message -- From: CAN Date: Nov 3, 10:58 am Subject: Delete rows from a Sheet based on value found on previous cell To: MS EXCEL AND VBA MACROS I have a