invalid call or argument

  1. 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...
    • BOOTCAMP55
    • Thread
    • invalid call or argument invalid procedure call pdf run-time error '5' vba & excel
    • Replies: 2
    • Forum: Excel Questions
  2. E

    Run Time Error 5 Invalid Procedure or Error Argument - Repost

    Since this problem remains unsolved, I want to retry this post to see if anyone can find the problem. I have a run time Error 5, Invalid Call Procedure or Error Argument. The offending code is: Output_t1 = GrowthFactor ^ (Period_Length) * (Output_t0 + FactorProductivity * (1 -...
  3. E

    Run Time Error 5 Invalid Procedure or Error Argument

    The code where the error code occurs is as follows: 'Calculate Production function Output_t1 = GrowthFactor ^ (Period_Length) * (Output_t0 + FactorProductivity * (1 - Damages_Production_t1) * _ (1 - AbatementCost_Production) * (CapitalStock_t1 - CapitalStock_t0) ^...
  4. B

    Just not my day: Invalid procedure call or argument

    Hello everyone,I'm still having issue with a previous post.I've made the changes to my Macro but I'm getting a invalid procedure or argument error when C9 = "OK to submit". The correct msg box appears when C9 reads "Fields left to complete"When I debugger it shows this line...I've checked it...
    • bemcbride
    • Thread
    • email active workbook invalid call or argument macro - help msg box vba & excel
    • Replies: 3
    • Forum: Excel Questions
  5. N

    Macro run-time error:5 - Creating a new pivot from a pivot

    Caveat - I am brand new to posting on this board and quite new to macros. That being said, I have created a macro with part recording and part hand-editing that makes a new pivot table from a pivot table made by another macro. I ran the macro quite a few times successfully, then I started...
    • nellesplace
    • Thread
    • error 5 invalid call or argument macros pivot table variable rows
    • Replies: 2
    • Forum: Excel Questions

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
Back
Top