run-time error 438

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

Hi, I have a user who has a macro enabled workbook from an older version of Excel where at runtime, a menu was created. He has just migrated to the latest version of Office for Mac and it seems that the function is no longer supported. Do you have an idea of how I can create the menu items...

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

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

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

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

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