ls(i + 1, 1), 4) = Left(Cells(i, 1), 4) Then Rows(i).Delete
> Next i
> End Sub
> ===
>
>
>
> -Original Message-
> From: Gaetan M
> Sent: Tuesday, August 30, 2011 4:14 PM
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Macros$$ Macro to remove
of B1.
Is this something that can be done?
Thanks
On Aug 30, 11:33 pm, Venkat CV wrote:
> Hi,
>
> You can try Remove duplicate's option in Excel 2007 or 2010 use ALT+A+T
>
> *Best Regards,*
> *Venkat *
> *Chennai*
>
>
>
>
>
> On Wed, Aug 31, 2011
I have the following:
Column A B C D
E F
12722 12722 51.564.89 RNLOX
12723 12723 51.564.89 RNLOX
Would you have the solution to replace B1 by B2 and delete row 2 once
completed since they have been
