I am trying to write a sub procedure that will delete all table rows if the IT column value is equal to OO
I need the procedure to filter the table on the IT column where values equal OO, and from there just delete all of the sheet rows with that value. However, I am getting “run-time error ‘1004’: delete method of Range class failed” when I try to write this sub procedure. Any suggestions would be appreciated!
Error 91 when activating newly opened Workbook
I’m running into this error:
Error 91 when activating newly opened Workbook
I’m running into this error:
Error 91 When Activating Defined Variable Workbook after using Function to Open said Workbook
I’m running into this error:
Excel VBA Paste Issue
Below is my sub routine. The line below is where the code stops every single time with 1004 error message. When I hit “Debug” the sheet seems to populate with the copied data and I continue on with the code without any issues until it comes back to the line again and the same error presents itself. It is like the copy of the values isn’t finished.
Excel VBA ‘Method Value of Object Range failed’ Automation Error
I am doing an userform in VBA. this form to add new hardwares to the sheet ‘App hardwares’. I have a main menu where you can access the open form then the add form and the add form can also be access via a sub menu. The open menu is for listing all hardwares I have. When a new hardware is added from the sub menu it works fine but from the main menu, I got ‘Method Value of Object Range failed’ then Excel just crashed.
Calling methods on Word Doc error: Excel VBA throws run-time error 438: Object doesn’t support this property or method
I’ve been working on this test code for a larger project for a few days, and keep running into these 438 errors. I received help with the first one here: 438 Error, but now that it’s getting further, I’m getting the error on any and all methods on WordDoc. The idea is just to do a find/replace based on values in a spreadsheet against placeholders in the template doc (copied to avoid conflicts). As far as I have found, word docs have .Content.Find.etc methods, but I can’t get this to run through to complete my tests.
Excel VBA 438 error when using thisworkbook and word application in same script
I’m testing out a method for a bigger project and am running into 438 errors for this script. If I grab the worksheet first, the error comes from calling word.application, if I grab the word doc stuff first, the 438 throws when I grab the worksheet. I cannot find any viable solutions for this, though I did try early binding, and have begun copying the document first so that it’s always working in a fresh Word doc to avoid other conflicts. What else could be the issue here?