Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #9  
Old 01-27-2012, 05:29 AM
JBeaucaire JBeaucaire is offline how to view hidden rows Windows XP how to view hidden rows 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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
how to view hidden rows hidden rows gsrikanth Excel 5 01-19-2012 02:40 PM
how to view hidden rows merging rows and creating sub-rows gib65 Excel 2 12-09-2011 02:09 PM
how to view hidden rows Hidden tables? dluhop Word Tables 1 09-04-2011 02:41 AM
how to view hidden rows 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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:56 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft