| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Duplicate Values
Set up a loop increment LineNo. Delete and shift cells up.
If DataA2 = DataA1 Then Range("A" & LineNo + 1).Select 'Select & delete cell Data2 Selection.ClearContents Selection.Delete Shift:=xlUp End If |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| DUPLICATE VALUES | Excel Discussion (Misc queries) | |||
| Why does this code remove Duplicate Values, by showing only 1, but it does NOT show Unique values for some reason ? | Excel Programming | |||
| DUPLICATE VALUES | Excel Worksheet Functions | |||
| Duplicate values | Excel Worksheet Functions | |||
| Sum of Duplicate Values | Excel Worksheet Functions | |||
Threaded Mode
