Re: $$Excel-Macros$$ Re: find duplicate rows of data between sheets macro

2014-04-29 Thread Eugene Bernard
an.” - John Wesley* > - > >*From:* Eugene Bernard > *To:* excel-macros@googlegroups.com > *Sent:* Monday, April 28, 2014 11:49 AM > *Subject:* Re: $$Excel-Macros$$ Re: find duplicate rows of data between > sheets macro > > Hi Paul,

Re: $$Excel-Macros$$ Re: find duplicate rows of data between sheets macro

2014-04-28 Thread Paul Schreiner
11:49 AM >Subject: Re: $$Excel-Macros$$ Re: find duplicate rows of data between sheets >macro > > > >Hi Paul, > > >The code given above works well for the sheets in same workbook. >send me the code for data in two different work books. > > >Regards >Euge

Re: $$Excel-Macros$$ Re: find duplicate rows of data between sheets macro

2014-04-28 Thread Eugene Bernard
Hi Paul, The code given above works well for the sheets in same workbook. send me the code for data in two different work books. Regards Eugene On Fri, Apr 25, 2014 at 9:15 PM, Paul Schreiner wrote: > It works perfectly in my workbook. > Row 6 is unhighlighted in sheet1 > and 6 and 13 are unhi

Re: $$Excel-Macros$$ Re: find duplicate rows of data between sheets macro

2014-04-25 Thread Paul Schreiner
It works perfectly in my workbook. Row 6 is unhighlighted in sheet1 and 6 and 13 are unhighlighted in sheet2.   better check to make sure the macro was copied correctly, here it is from my workbook:   Option Explicit Public Dict_Data1, Dict_Data2 Sub Compare()     Dim Sht1, Sht2     Dim nRows, r, s

Re: $$Excel-Macros$$ Re: find duplicate rows of data between sheets macro

2014-04-25 Thread Paul Schreiner
Must be something I changed when I went to test my large sample.   I'll take a look at it. Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As