Pam Simpson
Oklahoma
Member
Members
Dashboards
Power Pivot
Dashboards
Power Pivot
Forum Posts: 20
Member Since:
June 25, 2016
June 25, 2016
Offline
Hello,
I am wanting to make sure that filters are cleared from a specific table in my workbook when the workbook is opened.
This is what I have tried, but I get an error...
Private Sub Workbook_Open()
'Clear filter on the Orientation Log table
Worksheets("Sheet2").ListObjects("OrientationLog").ShowAllData
End Sub
Thank you for your assistance.
SunnyKow
Puchong, Malaysia
VIP
Members
Trusted Members
Trusted Members
Forum Posts: 1432
Member Since:
June 25, 2016
June 25, 2016
Offline
Pam Simpson
Oklahoma
Member
Members
Dashboards
Power Pivot
Dashboards
Power Pivot
Forum Posts: 20
Member Since:
June 25, 2016
June 25, 2016
Offline
Hi SunnyKow,
Thank you for your post. I tried it, at first I got the error: "Run-time error '9': Subscript out of range".
Then I realized that I needed to replace the "Sheet2" with the name of my worksheet tab "Orientation Log" and then it worked!!! SO YAY!!
I appreciate the help! 🙂
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Alan Sidman, Stacy Culpepper, Sheryl Gill, James Heaney Regalado, Teodor Kolev, Ryan Tyree
Guest(s) 8
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1917
SunnyKow: 1432
Anders Sehlstedt: 900
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 286
lea cohen: 246
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Marisa Bradshaw
Eugene Augustine
MacNaughton Finance
Tanu Rai
Ryan Tyree
Taza Tarwala
Ryan Tyree
Nishi Gurupersad
Tony Johlie
Ben Gerrey
Forum Stats:
Groups: 3
Forums: 24
Topics: 6871
Posts: 30100
Member Stats:
Guest Posters: 49
Members: 33661
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —