Thread: Type mismatch accessing variant array too many times
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
peter peter is offline
external usenet poster
  
Posts: 23
Default Type mismatch accessing variant array too many times
Thanks for your msg Peter.

aAllArrays(1, 3) is Nothing because I've put nothing there.

The problem is I can't figure out how to test for it.
The foll. crashes with "object reqd":
If aAllArrays(1, 3) Is Nothing Then _
MsgBox "Nothing here"




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Reply With QuoteReply With Quote