Thread: [Solved] how to view hidden rows
View Single Post
 
Old 01-27-2012, 05:29 AM
JBeaucaire JBeaucaire is offline Windows XP Office 2003
Advanced Beginner
 
Join Date: Dec 2011
Posts: 51
JBeaucaire is on a distinguished road
Default

This version will hide all rows, then unhide the ones you have entered in popup box:

Code:
Option Explicit

Sub ShowOnlyCertainRows()
Dim RowNums As Variant, LR As Long, Rw As Long

RowNums = Application.InputBox("Show which rows?", "Show", "1,10,11,100,101,102,150", Type:=2)
If RowNums = "False" Then Exit Sub

Application.ScreenUpdating = False
With ActiveSheet
    .UsedRange.Rows.Hidden = True       'hides all rows, doesn't work on AutoFilter
    RowNums = Split(RowNums, ",")
    
    For Rw = LBound(RowNums) To UBound(RowNums)
        .Rows(RowNums(Rw)).Hidden = False
    Next Rw
End With

Application.ScreenUpdating = True
End Sub
Reply With Quote