报错的是否为For i = Sheets("abe").Range("E" & Rows.Count).End(xlUp).Row To 2 Step -1这句？请确认是否存在abe工作表。
"Run-time error '1004': Application-defined or object-defined error" Here’s what this error generally means: Application-defined: This means the error was triggered by the Microsoft Excel application itself. This can be due to issues like incompatible Excel versions, file corruption, or resource...
I have yet another runtime error; this time it's 1004 instead of 6. Again, this code was originally French and I did not make it myself.
Yesterday was the first time I have had to use it after several months, and I got this error. When I click debug, it highlights this row: Copy .Rows(i).Copy Destination:=Sheets("Sheet2").Range("A" & Rows.Count).End(xlUp).Offset(1).Resize(.Range("E" & i).Value) C...
{"__ref":"Forum:board:ExcelGeneral"},"subject":"Re: Run-time error '1004': application-defined or object-defined error","readOnly":false,"editFrozen":false,"moderationData":{"__ref":"ModerationData:moderation_data:180509"},"parent":{"__ref":"ForumTopicMessage:message:180...
提示给你的是定义类型错误 个人推测是因为你没把工作表名改正确，Sheets("Summary").和Sheets("Pricing").是否能在表格中找到。这句代码本身没其他问题。
"VB: run-time error 1004": Application or Object-defined error. "Select method of Range class failed": Excel VBA Runtime error 1004. "Run-time error 1004"- Excel macro. "Runtime error 1004" This error occurs when method open of object workbooks failed "Run time error 1004" This error...
EXAMPLE 7: VBA Runtime Error 1004: Application-defined or Object-defined error This error encompasses a wide range of possibilities. The error is triggered due to violating one of the rules that are used to handle the object you’re working with. ...
在该句前加个：msgbox "=roundup(" & Sheets("Pricing").Cells(10, 12).Value & ", 4)"检查显示的内容是否符合函数语法
Run I_PROCESS "sNewfilenameKPS ??End Sub ???test result: ??1) Test with 9.5.1 and Excel 2003 -> everything works fine ???2) Test with 9.5.1 and Excel 2007 -> when the macro I_PROCESS is called, "Runtime Error 1004 Application-defined or object-defined error" occurs ???Note:...