"Run-time error 91"是一种常见的运行时错误,通常在使用Visual Basic for Applications (VBA)编程语言时出现。该错误表示对象变量未设置或未引用对象。 在VBA中,对象变量需要通过Set语句进行实例化,否则它们将被默认设置为Nothing。当尝试在未设置对象变量的情况下访问其属性或方法时,就会引发"Run-time error 91"错...
2 Conditional copy Excel File-2 data to excel file-1? 14 Excel VBA - read cell value from code 0 Copy rows to a new sheet using command button 1 Is possible to limit a row selection? 591 Is there a way to crack the password on an Excel VBA Project? 0 copy and pasting area n...
1 Run Time Error '91' 1 Outlook Vba Code gives an error 1004 0 Run-time error 91 0 run time error 91 vba 0 Runtime error 91 vba 0 Excel VBA Run-Time Error 91 0 Vba runtime error: 91 1 Excel VBA code working except one computer - Error 91 1 Run time error 91, ...
The when I run it, the code that pops-up (In the title) RUN TIME ERROR '91': OBJECT VARIABLE OR WITH BLOCK VARIABLE NOT SET and It highlights the .Title=... in the first macro N.B. see attached Contact MANAGER File ___ What should I do next Please help...
Excel (Version 16.45[microsoft 365]) macOS Big Sur Hi Geniuses! I'm trying to put together a contact manager document in Excel and I'm...
Sub test_click()Dim x, y textline = "TC_NO=1,Action=NEW-REJ-HK ,Case=0497 ,Order_ID=YYY1,Result=Fail" textline = Replace(textline, "=", ",") textline = Split(textline, ",")Cells(1, 1) = textline(3) myrow = Sheets("Sheet4").Cells.Find(textline...
'检测是否有其他工作簿打开If Workbooks.Count > 1 ThenMsgBox "Detect other workbooks open, please close other workbook.", 16, "Warning"'Workbooks.CloseEnd If'获取当前工作簿名称vBookName = ThisWorkbook.NameWindows(vBookName).Activate'关闭删除工作表提示Application.DisplayAlerts = False'删除...
名字为sheet1的工作薄不存在。直接改成：sheet1.range("b10").currentregion.copy
第一，你的split函数分割的分隔符没有设置，可能是你出错的问题所在 第二，如果你设置正确的分割符后，还出现这种情况的话，那么你要确保你保存的文件记录中，第一个数据是日期类型的，第三个数据是数据类型的，比如，你的文件中是用【，】来分割，那么，文件的内容应该跟下面的例子差不多：2010/10/...
Hello. I have a very simple code in VBA that inexplicably fails in the immediate window. The code is: prettyprint Workbooks.Open FileName:="C:\Users\myuser\Documents\workbook1.xls", UpdateLinks:=False, ReadOnly:=True ActiveWorkbook.SaveAs FileName:="C:\Users\myuser\Documents\workbook2.xlsx...