I need a vba module to check the duplicate cells value of each row
against other rows within the worksheet. The duplicate cells value do
not necessary be the same columns.

If the duplicate count is =10 times ,then the row will be hidden.

The check will start at the first row until the last row. This routine
will continue until the last row of the worksheet.
What I needed is to hide all the rows in the range when the count
compare is =10
The worksheet range is from A7:T3000.

I also need the unhide routine to reset back to normal.

Thank you for any help given.

Regards
Michael168



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Being worked in an earlier posting.

--
Regards,
Tom Ogilvy

"Michael168" wrote in message
...
I need a vba module to check the duplicate cells value of each row
against other rows within the worksheet. The duplicate cells value do
not necessary be the same columns.

If the duplicate count is =10 times ,then the row will be hidden.

The check will start at the first row until the last row. This routine
will continue until the last row of the worksheet.
What I needed is to hide all the rows in the range when the count
compare is =10
The worksheet range is from A7:T3000.

I also need the unhide routine to reset back to normal.

Thank you for any help given.

Regards
Michael168



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/