run time error 438

  1. M

    VBA Run-time error ‘438’ - Unknown Reason

    Hello, Developing a code in Excel VBA for work (code at the end of this post) and I am running into the following error a few times in the code: Run-time error ‘438’: Object doesn’t support this property or method This code (full code posted below at end) is executed in one workbook, opens...
    • MWSC18
    • Thread
    • 438 error 438 run time error 438 run-time error run-time error 438 runtime error 438 vba & code workbooks.open filename
    • Replies: 2
    • Forum: Excel Questions
  2. A

    VBA Help - Excel and Outlook

    I have a macro in Excel to go into a specific Outlook folder. For all emails in that folder I want to copy the sender email address, subject, body, and date into Excel. When I run the code it returns a an error 'Run-time error 438: Object doesnt support this property or method'. Can someone...
  3. C

    Referencing Dim in VLOOKUP

    Hate to bump, but I'm stuck..... I posted Friday, but with 56 views, I'm the only post without a reply through Sunday, so I'll try to parse my inquiry. VLOOKUP Macro Workbook Reference Variable Range("J2").FormulaR1C1 = _ "=IFNA(VLOOKUP(RC[-5],[" & wkb3 & "]!C5:C9,5,0),"""")"...
  4. J

    Run-time Error 438: Object doesn't support this property or method

    Hello everyone, I am getting an error on the code below (bold/underlined code) that says "Run-time Error 438: Object doesn't support this property or method".... Any thoughts/ideas on why I am getting this error and how it can be fixed? Sub Insert_Rows() Dim sh As Worksheet Dim End_Row As...
  5. Prevost

    Run Time Error 438

    Hi There. I have found lots of discussion revolving around this error, but I did not see a solution or I am not understanding fully the nature of this issue. I am trying to open up all the Excel files in a folder and perform the same set of actions on them. It is fine until I hit the row that is...
  6. M

    Run Time Error 438 And AdvancedFilter

    I am hung up on one of those wonderful Run Time Error 438 situations. This is the code: Selection.AdvancedFilter Action:=xlFilterCopy, _ CopyToRange:=Workbooks("Replenishment Reports.xlsm").Sheet2.Range("A2"), Unique:=True I'm trying to copy only the unique values of a column (Selection) to...
  7. J

    Updating Access Database with Excel File

    Hello, I've been trying to make this work for hours and hours and am finally giving up. Most of this code was found on the internet and I've attempted to make it work for my project but I keep getting errors. I use VBA with Excel quite often but never with Access before. Currently I am getting...

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