Home |
Search |
Today's Posts |
#3
![]() |
|||
|
|||
![]() Quote:
Sub HideFinishedColumns() Application.ScreenUpdating = False a = Range("H" & Rows.Count).End(xlUp).Row For b = a To 1 Step -1 If Cells(b, 8) = "F" Then Rows(b).Select Selection.EntireRow.Hidden = True End If Next b Application.ScreenUpdating = True End Sub Sub ShowAllColumns() Application.ScreenUpdating = False Cells.Select Selection.EntireRow.Hidden = False Range("A1").Select Application.ScreenUpdating = True End Sub
__________________
Asobi Wa Owari Da |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
hide & unhide toggle button | Excel Programming | |||
Hide/Unhide Toggle | Excel Programming | |||
Toggle Command Button to Show/Hide the Shaded Headers Columns | Excel Programming | |||
Hide/Unhide columns using button on top over relevant columns | Excel Discussion (Misc queries) | |||
Syntax of hide/unhide personal.xls toggle | Excel Programming |