im not very good with vba. I want to set the slicers on a separate workbook to yesterdays date. heres what i have so far. Getting an error on
For Each si In sc.SlicerItems
Please Login or Register to view this content.
im not very good with vba. I want to set the slicers on a separate workbook to yesterdays date. heres what i have so far. Getting an error on
For Each si In sc.SlicerItems
Please Login or Register to view this content.
Hi,
What is the actual error message?
Don
Please remember to mark your thread 'Solved' when appropriate.
Any ideas? I can get this code to work if the slicer is in the macro workbook using Thisworkbook.Sc etc..
I know theres just some syntax error somewhere when i do it like this.
Edit: Added this sheet that i got working but cant figure out why it doesnt when i call another sheet.
Last edited by beaglesBuddy; 07-27-2017 at 11:27 AM. Reason: Adding working sheet
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks