It worked!! Brilliant - thanks Bruno

"Bruno Campanini" wrote:

> "Minuette" <Minuette@discussions.microsoft.com> wrote in message
> news:4AA0D143-D4F0-4436-B3DF-17110478B2BF@microsoft.com...
> > Hi Bruno,
> >
> > Thanks for the info. I have never used Visual basic before so have copied
> > and pasted your work and then changed the data ranges.
> >
> > Unable to run it - keep getting 'Syntax error' on Sub ComparingData ()
> > line.
> >
> > It's obviously beyond me but thanks so much for trying.
>
> How did you try to run the procedure?
> You should run it by clicking the Button you've previously
> assigned the macro to, or execute ComparingData from
> the immediate window.
>
> Ciao
> Bruno
>
>
>