run-time error 438

  1. A

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

    Good Afternoon I'm formatting these large spreadsheets that contain mostly text. I'm trying to find characters used as bullets (Chr(149)) to format them. The code below gives me a run-time error 438 on this line: If .Characters(i, 1) = SearchValue Then I have tested the code by changing it to...
  2. R

    Run-time error '13' - Userform

    Hi folks I've managed to put together my first Userform from advice on here and put together my macro again with information from this site but I have hit a brick wall. Running the below brings up my form, allows me to enter values (e.g. ExtV = 10 and IntV = 10) but the error message...
  3. B

    '438: Object Does not Support' error with breaking links via VBA

    Afternoon folks, I've got a list of files in Column A of a sheet (path and filename), with a modified-date in column B and file-size in column C. For each item in the list, I want to open the file in Column A, break the links to other workbooks, save and close the file, then return the new file...
  4. R

    Help! "Run-time error 438: Object doesn't support this property or method"

    Hello! I think I might be doing something dumb because my code isn't that complicated, but...I keep getting a run-time error on the following bit: With WB1.Sheets(1) 'Count number of rows: x = .Range("A1048576").End(xlUp).Row 'Find Test Name column: TestCol =...
  5. D

    VBA - Create an instance of a class and pass it to a function - how?

    Hi all, I've got a small class module containing 5 properties, all with Get and Let methods. I can create an instance of the class and assign values to the properties, like this: Dim currentSite As New Site currentSite.DateRange = "B9:AF9" The 'currentSite' variable then needs to be passed...

Watch MrExcel Video

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