Previous Topic Next Topic

Hide rows in multiple sheets

Closed
philippos - May 10, 2010 at 01:49 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 11, 2010 at 11:22 AM
Please help me

If I have data in range A1:D35 in every sheet of the 20 active sheets, so I want to write a macro to hide all the rows that have a zero value in the C column in all the active sheets.
Thanks in advance to all your assistance.

2 responses

Answer 1 / 2
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 10, 2010 at 02:17 PM
See this

https://ccm.net/forum/affich-314244-hide-rows-with-zero-value-in-multiple-sheets
0
philippos
May 11, 2010 at 11:09 AM
not solved, i don't need filtering.
0
Answer 2 / 2
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 11, 2010 at 11:22 AM
Ok then see this
https://ccm.net/forum/affich-329160-conditional-hide-rows-in-multiple-sheets
0

Similar discussions

Excel - IF function with multiple words
Nick -
user -

14 responses