Can't test for Empty objects in an array
I'm writing Excel macros using VBA under XP and I'm having a problem testing
for Empty objects in an array.
The debugger shows an element is Empty, but if I separately test for either
'Is Empty' or 'Is Nothing' I
get 'Object required'
Thanks for your help,
Peter.
|