View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default Variant array is empty problem

Hi

Try

Dim Site as Variant, Test as Long
If IsEmpty(site) Then
test = 1
Else
test =0
End If

--
Regards

Roger Govier


wrote in message
ps.com...
I have written this code and for some reason i cannot make the logic
work correctly.

Dim site()
If IsEmpty(site) Then
test = 1
Else
test =0
End If

It always makes test = 0 when I am trying to get it to trip the logic
trap and create an output of test = 1. Thanks in advance for any
help.

-perry