rhombus4
Well-known Member
- Joined
- May 26, 2010
- Messages
- 586
- Office Version
- 365
- 2016
- Platform
- Windows
Currently have code below to clear all Timelines which works.
However if one of the Columns which has dates gets cleared completely or if one of the columns has a faulty date or text the Timeline relating to that column disappears. Same happens with Refresh All
However if one of the Columns which has dates gets cleared completely or if one of the columns has a faulty date or text the Timeline relating to that column disappears. Same happens with Refresh All
VBA Code:
Dim cache As SlicerCache
On Error Resume Next
For Each cache In ActiveWorkbook.SlicerCaches
cache.ClearDateFilter
Next cache
On Error GoTo 0