Thanx a ton man
*Simple gr8*
On Thu, Jul 23, 2009 at 3:45 PM, vivek agrawal wrote:
> hi mahesh...
> though i have already sent a code... you can use the code below... it would
> serve the purpose in a better way..
>
>
> Sub highlight_duplicate()
hi mahesh...
though i have already sent a code... you can use the code below... it would
serve the purpose in a better way..
Sub highlight_duplicate()
Dim vClmn(1 To 2) As Range
Dim vCnctnt_Values() As String
Dim vCells As Range
Dim vRows_Count As Inte
hi Mahesh
below is the code which u can copy and use
===
Sub highlight_duplicate()
Dim vClmn(1 To 2) As Range
Dim vCnctnt_Values() As String
Dim vCells As Range
Dim vRows_Count As Integer
Dim vColor() As Integer
Set vClmn(1) = Range([b2], [b2].End(xlD
ok ok
now i got the query,.., will try to get a solution soon...
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Thu, Jul 23, 2009 at 12:51 PM, Mahesh wrote:
> Hi vivek,
>
> I want that if both columns are same then it will be
Hi,
Please check the attached excel
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Mahesh
Sent: 23 July 2009 PM 12:52
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Duplicate colmuns
Hi vivek
Hi vivek,
I want that if both columns are same then it will be highlighted else not.
Example:-
A B
1 12N0044 076E5920 2 12N0648 076E5920 3 12N0650 076E4039 4 12N0650
076E4039
As u see in above example
B1 & B2 are same but they not highlited, but A3 & B3:
ish Jalendran
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-mac...@googlegroups.com] *On Behalf Of *vivek agrawal
> *Sent:* 23 July 2009 AM 10:49
>
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Re: Duplicate colmuns
>
>
>
>
hi mahesh
The requirement is still not clear...
can u please explain which values u want to compare and in what manner to
highlight
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Thu, Jul 23, 2009 at 9:20 AM, Mahesh wrote:
>
