Forum Home
Press F1
Thread ID: 12549	2001-11-01 02:37:00	Excel Macro - followup Russell D.	Guest (0)	Press F1

Post ID	Timestamp	Content	User
23283	2001-11-01 02:37:00	Can I adapt the 'Fix Duplicate Code' to 'just' highlight the duplicates. PS- the code worked great. Thanks	Guest (0)
23284	2001-11-01 03:33:00	I have interpreted 'hilight' to mean change the cell colour - in this instance to yellow. In the macro replace the line- Cells(RowNdx, ColNum).Value = 'ZZZZ' with Cells(RowNdx, ColNum).Interior.ColorIndex = 6 That's all that is needed, as no rows will be deleted as there will be no cells containing ZZZZ. HTH	Guest (0)
23285	2001-11-02 00:58:00	My Leadership today explained a little better what they were reaching for on this. Briefly the spreadsheet lists colums 'A - N' Columns G,H,K.L are the ones being looked at for duplicates. 'If they are dup's then it means we are paying out too much'. Columns are: G= Division number-ie 27 H= Item code- 6 digits K= Date- example 4/4/02 L= Profile type-ie AAA1 I have to pull up the highlighted rows and verify if they are indeed duplicate billing or if someone put the same bill in twice in error. Anyway that's the long and the short of it. Can this be done? Thanks!!	Guest (0)
1