run time error 5

  1. J

    Run-time Error 5: Invalid Procedure - Changing Pivot Table Source

    Hi, I'm getting the "Run-time error '5': Invalid Procedure call or argument at the line below in blue: PT1.ChangePivotCache ThisWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:=PTSourceRngFcst, Version:=6) These are the values of the cells listed in the code: G24 =...
  2. N

    run time error 5 invalid procedure call or argument

    Hello friends, i am using macro for print, save and move data to next sheet but facing "run time error 5 invalid procedure call or argument " error, friends Anyone can tell me where is the problem in coding and my coding is below: ' Print, Save PDF, Transfer Data Private Sub...
  3. S

    ErrorHandling - RunTime Error 5 on Second Run

    I am attempting to write some error handling for the first time. I have written a bit which works correctly on the first go-through, but on the second run it generates a Run Time Error 5 Invalid Procedure Call or Argument. Sub PickFolder() tryagn: With...
  4. T

    run time error 5 in macro

    hello, i am trying to debug this code and am having a really hard time trying to find the root of this issue. the macro creates a simple pivot table and im not sure if there is a nother pivot table that has the same name and where to even locate this pivot table. i thought i started from...
  5. L

    Macro runs on one computer and get run time error 5 on another

    Hello! I run a macro on one computer and it is fine And on another it gives me the run time error 5: invalid procedure call or argument This is the code he doesn`t like: ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _ Range(Cells(1, 1), Cells(R, C))...
  6. G

    Run-time Error '5' in Outlook

    I pretty much changed few variable names from my old code. and i got "Run-time error '5': Invalid Procedure call or argument" Im very new to this website, so please help me. I dont even kno how to make that Code box. Thanks in advance...
  7. S

    Getting Run time Error 5 when updating a Pivot Table

    I am trying to update a pivot table. The following code works on my computer but on my colleague's computer displays-Run time error 5- invalid procedure call or argument. The error accurs on .ChangePivotCache line Sheets("DB for ECO Qty").Activate LastRow = Cells(Rows.Count, 1).End(xlUp).Row...
  8. B

    App Activate "Microsoft Powerpoint" Run Time Error 5

    Hi All, I have a code which will copy the charts in a workbook / worksheet and automatically create a PPT presentation by pasting the charts on individual slides (Please find the code below, the macro is also called Create PPT in VBA circles). Though the macro executes as intended, I have a run...
  9. N

    Need VBA pivot tables help

    Hi everyone, I am trying to make pivot tables by recording macros but always get this "run time error '5' Invalid procedure call or argument". It recorded it fine but doesn't work when I try and re-run it! Anyway here is the code can you please help!? Thanks...

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