| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 12424 | 2001-10-28 04:57:00 | Need Help! Excel Macro Code | Guest (0) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 22802 | 2001-10-28 04:57:00 | Is there a program code that will identify/highlight? duplicate entries on multi page spreadsheet? I have tried: Public Sub() Dim N As Integer Dim M As Integer Dim FirstCellToSort As Integer Dim LastCellsToSort As Integer Dim SortDescending As Boolean SortDescending = False FirstCellToSort = 1 LastCellsToSort = Cells.Count For M = FirstCellToSort To Last CellsToSort For N = M To LastCellsToSort If SortDescending = True Then If UCase(Cells(N).Name) >= UCase(Cells(M).Name)Then Cells(N).Move Before: =Cells(M) End If ElseIf UCase(Cells(N).Name) <= UCase(Cells(M).Name) Then Cells(N).Move Before: =Cells(M) End If Next N Next M End Sub |
Guest (0) | ||
| 22803 | 2001-10-28 20:54:00 | Just for clarification, Are the duplicate entries based on the same column or across a number of columns? Are the entries always text? Are you wanting to remove existing duplicates or to prevent the addition of new entries which already exist? |
Guest (0) | ||
| 22804 | 2001-10-30 01:34:00 | Numeric column. The numeric column is the one that I want to filter out any duplicates. Thanks for any help you have on resolving this code issue. |
Guest (0) | ||
| 1 | |||||