runtime 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 Everyone I have been creating a macro in excel that will pull information from an excel sheet and insert into a word document. After much trial and error I have managed to get it to insert all the information I want but I am now stuck on changing the formatting of what is inserted. After...

Hi, I have a macro that build PowerPoint presentation from excel. And workbook that has several tabs and their names as below: "It would take", "Themes_2", "Themes_1". When I tried to build the slides this is what happened: "It would take" tab successfully built into .pptx but the rest of the...

I have a form that people fill out, print, and scan to me. I want to set a macro so that when they hit print, it pops up a message box that reminds them I need their cover page and calculations pages. I have read dozens of help forum posts and copied many of the codes into sample excel sheets to...

So I am trying to slowly piece together a macro through trial and error (Mostly just error) Below is the very first part I need to accomplish & I get to here wbTarget.Sheets("AB").Range("A:H").Paste 'Last line And i get runtime error 438 Object doesnt support this property or method I'm...

Gaaah! Working on a macro to copy in a sheet from a daily report, into my "processing" workbook. The daily report worksheet to-be-copied will always be called "orange", so I figured when I copy it, I'll rename it "orange" + the number of sheets in the workbook (orange5 when sheets.count=5...

Hello all, I have a project where I am exporting an excel table to word and trying to add a watermark. Everything is working except for the watermark. When I put the watermark code in a Word module it works however in excel I'm getting runtime errors. I've added the Word library to so I'm not...

Hello all, I have a project where I am exporting an excel table to word and trying to add a watermark. The loop is as follows, Create folder, create word doc, add table to word doc, save, add watermark, save, close, loop. Everything is working except for the watermark. When I put the watermark...

Hi, I have completed my code with 2010 and have have checked it on 2007 and both work great. When I try and use it on excel 2003 I get the runtime 438 error. The error occurs (in bold) on the Sort portion of my code, shown below. Is there anyway I can modify the code to work with excel 2003...

Hi there. I'm trying to link a checkbox to another page, so when i click the checkbox it adds one to a particular cell in another workbook. So far here is my code Sub CheckBox1_Click() strFirstFile = "C:\Users\owner\Desktop\Test Over WBK" strSecondFile = ThisWorkbook If Sheet1.CheckBox1.Value...

Can anyone help, i keep getting a "Run-time Error 438: object doesnt support this property or method" when i run the Find code below, i've bolded the section is highlights in the code. Sub Find_First() Dim FindString As String Dim Rng As Range FindString = InputBox("Enter a...