![]() |
|
#9
|
|||
|
|||
|
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
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
hidden rows
|
gsrikanth | Excel | 5 | 01-19-2012 02:40 PM |
merging rows and creating sub-rows
|
gib65 | Excel | 2 | 12-09-2011 02:09 PM |
Hidden tables?
|
dluhop | Word Tables | 1 | 09-04-2011 02:41 AM |
Hidden style applied over already-hidden text.
|
christie | Word | 1 | 08-17-2011 09:10 AM |
| Hidden address | nicolapiva | Outlook | 2 | 11-16-2010 12:12 AM |