asked on Hide certain rows on tables
Dear experts:
I got a sheet with several data lists (from 2 to n) formatted as tables.
I wonder whether it is possible to ...
... loop thru all tables and
....hide rows 3 and 6 of each table using VBA
Help is much appreciated. Thank you very much in advance.
Regards, Andreas
I have attached a sample file for your convenience.
Hide-Rows-On-Tables.xls
I got a sheet with several data lists (from 2 to n) formatted as tables.
I wonder whether it is possible to ...
... loop thru all tables and
....hide rows 3 and 6 of each table using VBA
Help is much appreciated. Thank you very much in advance.
Regards, Andreas
I have attached a sample file for your convenience.
Hide-Rows-On-Tables.xls
Microsoft Excel
Last Comment
nutsch
ASKER CERTIFIED SOLUTION
Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Glad to help. Thanks for the grade.
Thomas
PS to speed up the macro, change the screenupdating parameters
Thomas
PS to speed up the macro, change the screenupdating parameters
Sub Makro9()
application.screenupdating=false
Dim loTable As ListObject
For Each loTable In ActiveSheet.ListObjects
loTable.Range.Cells(3, 1).EntireRow.Hidden = True
loTable.Range.Cells(6, 1).EntireRow.Hidden = True
Next
application.screenupdating=true
End Sub
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
super, vielen Dank. This did the trick. Great!