Hi -
I'm looking for a macro that will hide specified range of rows depending on the text found in a cell.
Specifically, in the attached workbook on the "Dashboard Tab", when the formula in cell D3 returns "Year 5", I want the macro to hide rows 5:143. If the formula in cell D3 returns "Year 1", I want it to hide rows 39:179.
Any help?
Thanks!Deliverables Tracker_Excel Forum_6-23-2014.xlsm
you attached a protected workbook
If solved remember to mark Thread as solved
try this attached file
Thanks - Naveed
-----------------------------
If the suggestion helps you, then Click * to Add Reputation
To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
You can add the others options
Sub a() If Range("D3").Value = "Year 1" Then Rows("39:179").Select Selection.EntireRow.Hidden = True End If If Range("D3").Value = "Year 5" Then Rows("5:143").Select Selection.EntireRow.Hidden = True End If End Sub
Hi, patel45,
there´s hardly a need to Select a range prior to doing any action on it. More obvious is that you would need to make sure that the entire area is visible prior to hide any rows, maybe add at the beginning
Ciao,Range("A5:A178").EntireRow.Hidden = False
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
jgray 
Register To Reply
Bookmarks