Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comparing and deleting duplicate cells
I am trying to compare the contents of a cell and the one below it. If it
is the same then delete the upper one.Have come up with this (please don't laugh): For cellcount = 1 To 500 If Cells(B, cellcount) = Cells(B, cellcount + 1) Then Cells(B, cellcount).Delete (xlShiftUp) End If Next Have absolutely no idea about Excel Macro's but am keen to learn, in fact this is my first shot so if someone could help with answers in one syllable!! FIA David Jacobs |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting/Clearing duplicate range of cells | Excel Worksheet Functions | |||
Deleting Duplicate cells function | Excel Discussion (Misc queries) | |||
Deleting Duplicate Cells in one Column. | Excel Discussion (Misc queries) | |||
deleting duplicate cells in several columns | Excel Worksheet Functions | |||
Comparing ranges and deleting | Excel Worksheet Functions |