View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] pltaylor3@gmail.com is offline
external usenet poster
 
Posts: 3
Default Variant array is empty problem

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