macros

D

Dorothea

I am trying to remove dup rows in an excel spreadsheet,
but my macro only deletes the dup out of the first column,
not the whole row and moves up the next item to replace
what it deleted.

Any suggestions
 
D

Dave Peterson

It's easier to work from the bottom towards the top (just in case you're not
doing it now).

And you can do this kind of thing to get rid of a row:

rows(i).delete
cells(i,1).entirerow.delete

But it's difficult to guess without seeing your code.
 
Top