Sub Update_Tabs()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
For Each r In ws.Range("B1:L1")
If r.Value = "No" Then
r.EntireColumn.Hidden = True
Else
r.EntireColumn.Hidden = False
End If
Next ws
End Sub
I am just trying to hide any column that says No in it's first cell on each sheet. I got it to work on just one sheet, but I am messing something up when I tried to add in the apply to all tabs part.
Anybody know what I'm doing wrong?
Thanks in advance
Hi tyler,
If you indent your code you would have found that you didn't provide a Next r.Also, and just to go one step further, you can declare r too, much like how you nicely declared ws
Please Login or Register to view this content.Please Login or Register to view this content.
If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.
---Keep on Coding in the Free World---
Ahhh you just made my day, thank you!
tyler, Im happy that you had your question resolved
For future reference, please ensure that your thread title complies with Forum Rule #1 about proper thread titles.
Thanks
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
And of course,
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
lol thanks Mordred, I missed that
I missed it all originally.
I guess I read the title, opened it and skipped to the bottom - saw that the question was answered and didnt look further
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks