View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dennis dennis is offline
external usenet poster
 
Posts: 202
Default Trying to create Macro to delete duplicate Rows

Hello,

I am hoping someone can help me. I am not an experienced macro writer and I
am having a problem on how to write a macro on deleteing duplicate rows. To
give you an example of what i am trying to do is:

I am trying to delete rows with duplicate information that is in column
A,S,T,U,V,W, Y, and Z.

But i want to leave at least one row with that info.

For example if row 1, 2, and 3 have the same info in A, S, T, U, V, W, Y,
and Z. I would want to leave row 1 and delete row 2 and 3.

I am hoping someone can help.

Thanks