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
>>&
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
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
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
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