Hi All,
Thanks in advance for any assistance with this it's much appreciated.
When selecting through the different buttons of a slicer I am getting the error message: 'Run-time error 5: invalid procedure call or argument'
The below code is what is running and receiving this error, I have changed the font for the part which Excel is highlighting as the problem. Does anyone know why this error would appear and how I can fix it?
![]()
Private Sub UpdateSlicers(ByVal scDashboard As SlicerCache, ByVal scLetters As SlicerCache, ByVal scLac As SlicerCache) Dim siDashboard As SlicerItem scLetters.ClearAllFilters scLac.ClearAllFilters For Each siDashboard In scDashboard.SlicerItems If Not (scLetters.SlicerItems(siDashboard.Caption).Selected = siDashboard.Selected) Then scLetters.SlicerItems(siDashboard.Caption).Selected = siDashboard.Selected scLac.SlicerItems(siDashboard.Caption).Selected = siDashboard.Selected End If Next siDashboard End Sub











LinkBack URL
About LinkBacks
Register To Reply

Bookmarks