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! This will be my first post to bear with me. I've ran into an odd problem that I hope someone has a solution to. I have a module that call several other moduels. The module works without errors. However, once i assign an Excel button to the macro and click it I get the following error...

Trying to select multiple last rows, but I am not sure how to do this in VBA. I've tried two different methods Run TIME ERROR '438' Object does not support this method Run TIME ERROR '450' Wrong number of arguments or invalid property assignment Sub DiffLondon() Dim ws As Sheets Dim Wkb As...

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

Hello everyone, I wrote a macro in an excel spreadsheet that takes data from excel and then places it in a word document template that the macro loads from the C drive. I wasn't sure how to make the bullet formatting properly, so i recorded a macro in word that essentially goes to a bookmark...