Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to hide and unhide rows
I have a worksheet contains 10,000 rows and columns A to H
The range is A1:H10,000. e.g. colums: A B C D E F G H 1) M N O P Q R S T 12) O P Q R S A B C etc 33) A B P Q R C D E 44) A B D G H I J K In the above example, row 1 will be hidden, row 12 will also be hidden, row 33 will not be hidden. This module will check present row against all the next rows in range (A1:H10000) , if it find 5 or more cells are equal , then the present row will be hidden and this will loop through the whole worksheet. The value does not neccessary be in the same column. e.g 2 a b c d e f g h h g f e d i j k the above example also treat as having 5 equal cell values. Thank you for the help. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automate Hide/Unhide Rows | Excel Discussion (Misc queries) | |||
Enabling option „Format rows“ to hide/unhide rows using VBA-code? | Excel Discussion (Misc queries) | |||
How to Hide and Unhide Rows | Excel Discussion (Misc queries) | |||
Macro that will unhide then hide rows | Excel Discussion (Misc queries) | |||
Hide Unhide Rows | Excel Discussion (Misc queries) |