+ Reply to Thread
Results 1 to 3 of 3

Invalid procedure call or argument

  1. #1
    Registered User
    Join Date
    02-05-2013
    Location
    New York, US
    MS-Off Ver
    Excel 2010
    Posts
    43

    Invalid procedure call or argument

    Hello, I have a Form Control Combo Box that when changed, updates a pivot table filter. I currently get the error Invalid procedure call or argument when making a selection change. My Pivot Table name is PivotTable1. I think it has something to do with the line below,


    Please Login or Register  to view this content.
    does this have to be strictly defined?, any insight would be appreciated,, I've pasted the rest of the code below.

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Invalid procedure call or argument

    Is Range("H5") on sheet Cascade as well? If not, qualify the sheet it's on....

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    02-05-2013
    Location
    New York, US
    MS-Off Ver
    Excel 2010
    Posts
    43

    Re: Invalid procedure call or argument

    Yes, its in the range H5. I just deleted the old pivot table and pasted in another fresh one, saved and closed the file and re-opened it and tried it. It works!
    However, now have to re-write all of the calculated fields..

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Invalid procedure call or argument (Error 5)
    By vop2311 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-08-2014, 07:27 PM
  2. Invalid Procedure Call or Argument?
    By aloha31 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-19-2013, 08:24 PM
  3. Invalid procedure call or argument
    By krish T in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-31-2010, 10:01 AM
  4. Invalid procedure call or argument
    By mqdias in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-08-2007, 06:01 AM
  5. Invalid procedure call or argument error
    By Patrick Simonds in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-12-2006, 06:45 PM
  6. Invalid Procedure call or argument
    By T De Villiers in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-25-2006, 10:05 AM
  7. Shell Invalid Procedure call or argument
    By rgans in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-05-2005, 12:23 PM

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