程序就是分割一串字符,然后用其中一個字符串“NEW-REJ-HK“”作為find函數(shù)的查找關鍵值Sub test_click()textline = "TC_NO=1,Action=NEW-REJ-HK ,Case=0497 ,Order_ID=YYY1,Result=Fail"textline = Replace(textline, "=", ",")textline = Split(textline, ",")myrow = Workbooks("DBMTS_RTVM_SCFR_April_Release.xls").Sheets("Regression Test").Cells.Find(what:=textline(3), LookIn:=xlValues, lookat:=xlWhole).RowEnd Sub運行報錯run-time erro '91' :Object variable or with block varible not set
請大家?guī)臀铱纯矗@個用法有誤嗎?正確的應該怎么用?
LEATH
2023-04-21 23:19:24