run-time error 5

  1. K

    RunTime Error 5

    Hi All, It seems an old question. I found so many posts regarding the same. But couldn't solve the error. I am trying to save my Active Sheet into a PDF using the following code. Initially, it worked fine. But recently it shows Run-time error 5. "Invalid Procedure Call & Argument". Please help...
  2. S

    Run-Time Error 5

    I inherited this piece of code for VBA, every time I try to run the program I end up getting a run time error 5. Previously I thought I had it debugged after putting in a pause, but that only worked for so long. I am working in excel 2013. The code is as follows: Sub FAANotice() Dim...
  3. C

    cell address and cell value

    Hi All I am trying to find the value/content in a cell address, but I run into run-time error 5. I don't know what is wrong, any ideas. My code is below: Private Sub ClaimCMB_Click() Dim Filename2 As String Dim Filename3 As String Dim FilePath2 As String Dim CSF As Workbook Dim CS As...
  4. X

    Set Object Variable inside an If/ElseIf Statement (Run-time error 5)

    This macro keeps giving me a run-time error '5'. Dim myOlApp As Object Dim MyItem As Object Set myOlApp = CreateObject("Outlook.Application") If Range("C6").Value = "June" Then MyItem = myOlApp.CreateItemFromTemplate(JuneTemplate) 'THE ERROR HIGHLIGHTS...
  5. M

    Pivot Table Data Source - External to Internal

    Hi everyone, I've been searching to find a way of changing my pivot table data source from Access file to a local excel sheet (of same file). Is that anyhow possible? When I select "Change Data Source" From PivotTable Tools / Options, it only allows me to select the second option, "Use an...
  6. M

    Run-time error 5 when creating a pivot table

    Hello, I am having problems with my VBA code. First, I can't get the selected cells to convert to number format (font in red). Second, I get run-time error 5 Invalid procedure call or argument when trying to create a pivot table (font in green). Any and all help is greatly appreciated! Sub...
  7. 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...
  8. 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...
  9. R

    VBA Save As Macro, Returning Run-time Error 5 on other machines

    Hey, New to VBA, mostly recording macros then editing what I can. I am trying to have a macro save a file as a PDF and extract the file name from a cell within the worksheet. The code works great on my computer but when I try to use it on any other computer it Returns run-time error 5. Here...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top