View Single Post
 
Old April 12th, 2005, 01:16 PM
rahzan rahzan is offline
Authorized User
 
Join Date: Jun 2004
Location: , , .
Posts: 24
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks.
The reason I need to do this is in passing many data-series in the form of a 2D array. Each series may start at different index values, so I need to designate the non existent data with a NaN.

I can create a method in a com-server which passes a Nan to its client, but without testing I can't tell what actually ends up in the vba variable. I thought to ask before I actually do this.

I could be wrong but I do think that I have seen Nan for variable-values in the watch window during debugging in the past.

Tim