| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hiding columns based on row 4 criteria
Your welcome
"Pierre" wrote: On May 30, 2:08 pm, Mike H wrote: Mike, worked like a charm. Thanks so much! Pierre Hi, Right click the sheet tab, view code and paste this in and run it. Changing True to false unhides Sub mariner() Set myrange = Range("W4:HE4") For Each c In myrange If Not IsEmpty(c) And c.Value = 0 Then c.EntireColumn.Hidden = True End If Next End Sub Mike |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count based on criteria from two different columns | Excel Discussion (Misc queries) | |||
| Hiding rows based on a criteria thru and event proceedure | Excel Worksheet Functions | |||
| Need to count based on different criteria in two columns | Excel Worksheet Functions | |||
| Sum based on criteria in rows and columns | Excel Discussion (Misc queries) | |||
| Hiding columns based on user/password | Excel Worksheet Functions | |||
Hybrid Mode
