How to test for Not Nothing
 

if I have a workbook object such as

dim wb as workbook

I know how to test if wb is nothing

but dumb question how do you test for Not nothing ???

if wb is not nothing then
wb.save
wb.close
end if

How to test for Not Nothing
 

If Not wb is Nothing then
HTH Otto
"jotor14" wrote in message
...
if I have a workbook object such as

dim wb as workbook

I know how to test if wb is nothing

but dumb question how do you test for Not nothing ???

if wb is not nothing then
wb.save
wb.close
end if

How to test for Not Nothing
 

Thanks sooo much.

"Otto Moehrbach" wrote:

If Not wb is Nothing then
HTH Otto
"jotor14" wrote in message
...
if I have a workbook object such as

dim wb as workbook

I know how to test if wb is nothing

but dumb question how do you test for Not nothing ???

if wb is not nothing then
wb.save
wb.close
end if