run time error 5

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 =...

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...

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...

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...

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))...

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...

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...

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...

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...