invalid procedure call

  1. J

    Run-time error '5': Invalid procedure call or argument; can't resolve

    I am trying to get a set of Excel files that are unique by campaign type with pivot tables for geographic regions in separate worksheets to instead be pasted values for each campaign type in separate worksheets in unique geographic region Excel files. I first change the .xlsx files to instead be...
  2. B

    Excel VBA run-time error - PDF creation macro

    I wrote a VBA macro that generates, saves, and opens a PDF of an array of sheets from an Excel workbook. The macro works for most users in my organization, but a few users have reported receiving an error message that states, "Run-time error '5': Invalid procedure call or argument." All...
  3. A

    trouble using Union and Index, Invalid procedure call or argument

    I am trying to paste some copied data from a group of cells on one sheet to a group of cells in another workbook. I keep getting the "Invalid procedure call or argument" error I am working with names from the name manager in both workbooks The error appears on the red area of code Suggestions...
  4. P

    Run-timer error '5" invalid procedure call or argument

    Hi, I recorded a macro to create a pivot table. so okay everything okay but when I run the macro to check if it goes smoothly it appears like this. Run-timer error '5" invalid procedure call or argument Run-timer error '5" invalid procedure call or argument...
  5. L

    Invalid Procedure Call or Arguement When changing Page item in Pivot table

    Please help. I have recorded vb that changes a page item in a pivot table when selecting from a combo box - similar to this video. http://www.datapigtechnologies.com/flashfiles/pivot10.html The recorded code that vb gives me works only if it's selecting the selection that was chosen when...
  6. D

    Run-time error '5': Invalid procedure call or argument

    Okay. So i am having an issue with my macro that creates pivot tables. Everything works fine the first time i run it but when i delete the pivot tables that were created and try to run it again i receive the error "Run-time error '5': Invalid procedure call or argument" one the second line...
  7. D

    Invalid Procedure Call Error Using InStr

    Hi All, I have a query in which there are 10 fields that contain text which I want to convert into integers. I want to take all of the numbers to the left of the "." (each one has a format of "xx.0bp", however it could also be "xxx.0bp"). I used the formula...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top