应该是Object doesnt support this property or method，可以附上代码共同研究学习。
this error occurs. “Run-time error “438”: Object doesn’t support this property or method” indicates that the referring object doesn’t support the property or method when executing the Excel VBA.
VBA error 438 occurs when you try to use a property or method that does not support by that object. as you know all objects have some properties and methods that you can use but there could be a situation when using a property or method that does not apply to a particular object....
对数值的排序依据是数值的大小、对文本的排序依据是文本首字母。但是对文本与数字组合形式，excel排序的...
Thanks I get error 438 on this instruction: SetDestmisc=Destwb.Sheets(shtno).Find(What:="DATE OF LAST AR",After:=ActiveCell,LookIn:=xlValues_,LookAt:=xlPart,SearchOrder:=xlByRows,SearchDirection:=xlNext,_MatchCase:=False) This is because Find is a method of the Range o...
调用工作表函数就可以了 这是最简单的方式 试下 Range("V2:V" & row1) = "=IF(RC[-1]=""shipped"",""shipped"",IF(OR((RC[235]=851)*(TYPE(RC[-1]*1)=1),(RC[235]=851)*(LEFT(RC[-1],2)=""JQ"")),""JQ"","""))&IF((RC[...
在VBA中,On Error语句用于错误处理。当代码运行时发生错误时,该语句将执行相应操作。 On Error语句有4种不同的使用方式: 1.On Error GoTo 0 代码停止运行在出现错误的行并显示错误消息。 2.On Error GoTo [标签] 当错误发生时,代码移至指定的行或...
这是一段由我编写且已经添加好注释的EXCEL VBA代码。 代码窗口里的代码 Sub 遍历error参数及描述() 'i:声明一个变量,sz():声明一个动态数组 On Error GoTo en '如果错误跳转至en: Dim i As Long, sz() As String For i = 1 To 65535 '负数未遍历,Transpose一次最多转置65536行 ...
在Excel中,IFERROR和FIND是两个常用的函数。IFERROR函数用于处理错误,当公式计算出错时返回指定的值;FIND函数用于在文本中查找指定的字符串,并返回其位置。 如果要将IFERROR和FIND公式转换为VBA代码,可以使用以下示例: 将IFERROR公式转换为VBA代码: 代码语言:txt ...
Reason #1: VBA Code Refers to Range that Doesn’t Exist We want to use anExcel VBA codeto add the number of sales reps in cell B5. If we run the below code, we will get the error message “Run-time error ‘1004’: Application-defined or object-defined error.” ...