invalid procedure call

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

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

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

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

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

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

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