View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Alan Beban[_2_] Alan Beban[_2_] is offline
external usenet poster
 
Posts: 783
Default ParamArray debug anomaly


Peter T wrote:


Perhaps I'm missing something but I don't see any anomaly. I would expect
this line to fail (where x is the ParamArray)
z = UBound(x(0)(1))


On reflection, I guess there does remain one slight anomaly. The Locals
window suggests that x(0)(1) is of type Variant, whereas

Typename(x(0)(1)) will throw an error.

Thanks again,
Alan Beban