Thread: Find double instances of a row
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ardus Petus Ardus Petus is offline
external usenet poster
  
Posts: 718
Default Find double instances of a row
Have a look at DataFilterAdvanced filter

HTH
--
AP

"fran_dk" a écrit
dans le message de
...

Hi!
I am new at Excel programming but not at VBA(I usually use Access).

Here is my problem:
I have a huge worksheet whith some double rows in it (all cells are
indentical). I need to find them and hide the second instance.

Can anyone help me with a macro that can do it in Excel 2000/2003?

Thanks in advance

Fran


--
fran_dk
------------------------------------------------------------------------
fran_dk's Profile:
http://www.excelforum.com/member.php...o&userid=32435
View this thread: http://www.excelforum.com/showthread...hreadid=522084



Reply With QuoteReply With Quote