424 error

Hello, I've been using VBA created by Ron De Bruin (Sub Copy_To_Worksheets()), and have managed to amend it to my needs save for one part. I can't seem to be able to use a worksheet template? This is the original code that works... Else 'Add a new worksheet...

Hi, I am getting a run time error 424 on the code below: If Sheets("Specs").Range("B4").Value = Application.WorksheetFunction.VLookup(Sheets("Specs").Range("B4").Value, Sheets("InvoiceInfo").Range("E1:E100"), 1, False).valu Then MsgBox "This is a fixed item. " Exit Sub...

Hello, I'm debugging this as I go, and I'm getting a 424 error on the VLookup line. I'm trying to load values from "04-Space" in the 2nd column into "JCX" in the 8th column, but only after checking to see if the 04-Space value is in the 1st column in 03-Floor. The reason for the variables is...

Hi all, thank you for taking the time to read this. I am currently working on a code in which an engine can be running in four possible states: On, Off, Automatic and Manual. I am trying to find the total number of hours it is running in manual. The code is as follows: 'START' Dim run_time As...

Hi I am relatively new to macro, so excuse my question. I keep receiving error '424' (object required) while trying to run the macro below: Private Sub MsgBoxProcessingCredits() Application.EnableEvents = True Application.ScreenUpdating = False If Target.Address =...

Hi I'm trying to make a chart and i use this code ActiveChart.SetSourceData Source:=Range(nom_projet_liaison_achat!K3, ActiveCell.Offset(0, 1)) Excel tells me : error 424 object required, i don't get why because the gaph did appear ...

I'm eceiving an Invalid Qualifier Error for LastPartNo in Sub InputPart, even though I have clearly defined it as an Integer before I tried to use it. I attempted dding a Temp Str type as a go between in case of a type mismatch. Still no luck. Ay help would be much apreciated! :) lSub...

Hi all, I'm currently making an excel workbook where a user inputs a range of data which gets processed and reorganised into a table like the one below found in the "Intermediate" sheet in the workbook. There can be anything from 1 series to dozens, even hundreds. <tbody> Name Y1 Y2 X1 X2...

Hi, there are lots of threads out there about this error (424), but I am not well versed enough in VBA yet to convert their problem and solution to my code, so I am hoping someone here can help me out. When I run the macro by itself, it works fine; but as soon as I try to call this macro in...

Excel 2003. I believe I've got everything working in the code up until: If rnGx = rnGy Then It loops once and then "Run-time error '424': Object Required" for the code above. Sub test1() Dim rnGx As Range Dim rnGy As Range Dim i As Long Dim xNum As Integer Dim yNum As...

Hi, these procedures belong to a rather long process, so I've pulled out only what I think is applicable. The first two procedures work fine. The second two procedures should work in the same way, only they don't. Instead, I receive a 424 on line 1 of Sub TransferAssociate(MyCell). So far...