Run-time error 424, Object required错误表明代码中尝试访问的对象没有被正确初始化或赋值。 检查子程序代码: 需要查看SumEveryOtherColumn子程序的具体代码,找出引发错误的代码行。由于你没有提供具体的代码,我将提供一个假设性的代码示例来进行分析。 vba Sub SumEveryOtherColumn() Dim ws As Worksheet Dim sum...
一个弹出窗口显示“对象请求”错误信息,伴随着一个错误编号,Runtime error ‘424’: Object required”。 代码执行中断,并且通常会指明出问题的代码行。 处理方法: 处理“Object Required”错误的方法包括: 检查对象声明:确保在使用对象之前已经正确地声明并实例化了对象。 使用On Error语句:通过使用On Error语句,可以...
Although you have recorded using a macro and it should automatically play back, it doesn't seem to in the case of label text. You first have to create the AxisTitle object - an axis doesn't automatically have one. 解决方法: (1)删去宏内有关Axes的相关代码, 代码语言:javascript 代码运行次...
How to Fix Object Required (Error 424) in VBA Go to the Debug menu in your visual basic editor. Use the step to run the entire code step by step. The moment you reach the line where you have an error VBA will show you an error. Correct that line of code. The other way could be...
...相关资料: [1] Chart 方法 (Excel)(https://docs.microsoft.com/zh-cn/office/vba/api/Excel.Chart.Axes) [2] Run-time...Error '424': Object Required when setting AxisTitle.Text(https://stackoverrun.com/cn/q/8203932) [3]...Excel 2007 VBA Problem setting Axis Title(https://st...
I keep getting an error in Excel 2013 with the code below. Can't seem to figure out a solution, have tried several different solutions to no avail. Sub Submit() Dim excelRange As Range Dim Entries As New Collection Dim Entry As New Dictionary Dim row As Long Set excelRange = Cells(1...
("scripting.dictionary") For i = 1 To 10 key = Worksheets("Sheet1").Cells(i, "D").Value item = Worksheets("Sheet1").Cells(i, "L").Value DICT.Add key, item If DICT.Exists(key) Then DICT(key).Add item '(<-- causes runtime error 424, object required) End If Next i For ...
7.ActiveX component can't create object or return reference to this object (Error 429)ActiveX 组件无法创建对象或返回对此对象的引用(错误 429) 8.ActiveX component did not run correctly (Error 338)ActiveX 组件未正确运行(错误 338) 9.ActiveX component not correctly registered (Error 336)ActiveX 组件...
Georgina Sothcott-Gilson Thank you so much for replying, it worked! But... now it is saying 'Run-time error '9': Subscript out of range' Are you able to help with this one too? Thank you so much in advance. This line is the issue: Worksheets...
问Excel VBA运行时错误424:需要对象EN在VBA代码中，我们经常会看到类似于On Error Resume Next这样的语句...