$$Excel-Macros$$ Re: Need to color the duplicates

2009-09-23 Thread Harmeet Singh
Hi Sonia, If you open the VBE window, u will see a for each loop, that is changing the cell color for all the selected cells. Let me know if more clarification is required. :) Thanks & Regards, Harmeet Singh Sent via BlackBerry Wireless On Wed, Sep 23, 2009 at 1:34 PM, Sonia Singla wrote:

$$Excel-Macros$$ Re: Need to color the duplicates

2009-09-21 Thread Harmeet Singh
*opps gave u wrong file* *please check attached file (updated)* Thanks & Regards, Harmeet Singh Sent via BlackBerry Wireless On Mon, Sep 21, 2009 at 6:56 PM, Harmeet Singh wrote: > *See attached file and let me if it helps..* > Thanks & Regards, > > Harmeet Singh > > Sent via Bla

$$Excel-Macros$$ Re: Need to color the duplicates

2009-09-21 Thread Harmeet Singh
*See attached file and let me if it helps..* Thanks & Regards, Harmeet Singh Sent via BlackBerry Wireless On Mon, Sep 21, 2009 at 6:40 PM, Sonia Singla wrote: > Hi > > I have the data in an array say in nXm. I want to make a macro color the > cells with the same color having the same