Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Trying the sub below from a Mike H post
How do I reset it to full rows visible if I were to click on a cell other than A1 or A2? Private Sub Worksheet_SelectionChange(ByVal Target As Range) Select Case Target.Address Case Is = ("$A$1") Rows("10:20").EntireRow.Hidden = True Rows("21:40").EntireRow.Hidden = False Case Is = ("$A$2") Rows("10:20").EntireRow.Hidden = False Rows("21:40").EntireRow.Hidden = True End Select End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
full sheet charts not visible | Charts and Charting in Excel | |||
Why full contents of cell visible only by double clicking? | Excel Discussion (Misc queries) | |||
Excel workbook contents only visible in Full Screen mode ... | Excel Discussion (Misc queries) | |||
Rows not printing on full page | Excel Discussion (Misc queries) | |||
"Disk is Full" add-on question to "Can't reset last cell" post tod | Excel Discussion (Misc queries) |