View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Peter Chatterton[_4_] Peter Chatterton[_4_] is offline
external usenet poster
 
Posts: 20
Default 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.