| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide Columns On Condition
Sorry, forgot to put in the part about looping through months
If ActiveSheet.Name = "Main" Then If Not Intersect(Target, Range("B3")) Is Nothing Then For Each wsh In Sheets(Array _("Jan", "Feb", "Mar", "Apr", "May", _ "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec")) For Each c In wsh.Range("D3:P3") If c < Sheets("sheet1").Range("A2") Then c.Columns.ColumnWidth = 0 Else c.Columns.AutoFit End If Next Next End If End If End Sub *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide Rows If Condition True | Excel Worksheet Functions | |||
| How do I auto hide a row if a condition isnt met? | Excel Discussion (Misc queries) | |||
| hide rows where cell condition is not met | Excel Worksheet Functions | |||
| How do I hide a combo_box on a condition? | Excel Worksheet Functions | |||
| Hide a row based on one cell's condition | Excel Worksheet Functions | |||
Threaded Mode
