dim curRange as Range
set curRange = Nothing
if isNull(curRange)=false then 'Range 对象设置为Nothing时不对用isNull来判断,当对象为Nothing时用什么来判断?
...
set curRange = Nothing
if isNull(curRange)=false then 'Range 对象设置为Nothing时不对用isNull来判断,当对象为Nothing时用什么来判断?
...
end if
问题已经解决,判断方法是
if typeName(curRange) <> "Nothing" then
...
end if
标准的方法是: Not curRange is Nothing