怎样对查找数据结果值进行判断?空值时 if语句该怎么写?

hlzpf 2021-5-15 671

_怎样对查找数据结果值进行判断?空值时 if语句该怎么写?

objRet8 = Excel.Find(objExcelWorkBook,"Sheet1","A1:A"&h,sRet1,False,False)
            TracePrint(sRet1)
            If objRet8=Null
                
                Excel.DeleteRow(objExcelWorkBook,"Sheet1","A"&n,True)
                TracePrint(objRet8)
                Return retValue
                
            End If


最新回复 (3)
  • life 2021-5-16
    2
    Null 改""
  • 豆豆~ 2021-5-17
    3
    if objRet8 = ""
  • 七里 2021-5-17
    4
    if IsNull(objRet8) Or objRet8=""
返回
发新帖