Results 1 to 2 of 2

Run-time error 5: invalid procedure call or argument

Threaded View

Chips96 Run-time error 5: invalid... 04-07-2022, 09:51 AM
6StringJazzer Re: Run-time error 5: invalid... 04-07-2022, 10:40 AM
  1. #1
    Registered User
    Join Date
    04-07-2022
    Location
    Yorkshire, England
    MS-Off Ver
    2019
    Posts
    1

    Run-time error 5: invalid procedure call or argument

    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
    Last edited by Chips96; 04-07-2022 at 10:28 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA run-time error 5 invalid procedure call or argument
    By Chris.Leo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-13-2020, 05:31 AM
  2. [SOLVED] Run time error 5/Invalid procedure call or argument
    By Cicada in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-31-2018, 01:27 PM
  3. [SOLVED] Run time error 5 Invalid call procedure or argument
    By Sintek in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-28-2016, 06:31 AM
  4. Run-time error '5' - Invalid procedure call or argument
    By datutt in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-14-2015, 12:12 PM
  5. Run-time error '5' Invalid procedure call or argument
    By CCSlice in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-07-2015, 03:21 AM
  6. Run-time error 5, Invalid procedure call or argument
    By cmb80 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-23-2014, 08:29 AM
  7. [SOLVED] Run-time error '5': Invalid Procedure Call or Argument
    By Nikila in forum Excel General
    Replies: 2
    Last Post: 02-24-2006, 05:30 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1