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

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top