View Single Post
  #2   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

UPDATE
It looks like there's a problem with:
Set getNextOBJ = aAllArrays(iID, aCurrIndexes(iID))
It crashes everytime because of the Set which shouldn't be there.
I took it out and it now crashes when returning from getNextOBJ
in this stmt:
oCMD = getNextOBJ(ID_CMD) in main with:
"Object doesn't support this property or method."

I tried
Set oCMD = getNextOBJ(ID_CMD)
but get: "Object required"

But I still don't understand why altho I'll keep at it.
Maybe oCMD should be a Variant?




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