trivrain
12-12-2010, 03:56 PM
Hi,
Am looking for a VB code that allows to highlight duplicates with both duplicate FirstName & LastName - not just either one - and without having to resort to a concataner formula.
Ideally I would like it to prompt the user to select column1 and then column 2 so it it is transportable to any workbook and quicker for the amount of spread I have to sort this week:
Set Column1 = Application.InputBox("Select First Column to Compare", Type:=8)... Set Column2 = Application.InputBox("Select Second Column to Compare", Type:=8)or something flexible of that sort;
and make both FirstName & LastName cells fill red: Column1.Cells(intCell).Interior.Color = vbRed
Column2.Cells(intCell).Interior.Color = vbRedOf course having discovered VBA on saturday, well, erm... any help is appreciated.
t
Am looking for a VB code that allows to highlight duplicates with both duplicate FirstName & LastName - not just either one - and without having to resort to a concataner formula.
Ideally I would like it to prompt the user to select column1 and then column 2 so it it is transportable to any workbook and quicker for the amount of spread I have to sort this week:
Set Column1 = Application.InputBox("Select First Column to Compare", Type:=8)... Set Column2 = Application.InputBox("Select Second Column to Compare", Type:=8)or something flexible of that sort;
and make both FirstName & LastName cells fill red: Column1.Cells(intCell).Interior.Color = vbRed
Column2.Cells(intCell).Interior.Color = vbRedOf course having discovered VBA on saturday, well, erm... any help is appreciated.
t