View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default declare a two dimenssion array

Or you can just declare the whole array as variant and store what you want
in each element. Bit more overhead, however.

Or you could declare the whole array as long, and store only 0 or 1 in the
second dimension and have your code interpret it as boolean or treat it as
boolean and let vba coerce it.


Regards,
Tom Ogilvy

"Charles Williams" wrote in message
...
Hi Tomer,

There is a complex way of doing this using variants, but usually its

better
to have two separate arrays on Dim as long and the other as boolean.

(its usually faster to use long rather than integer).


hth
Charles
______________________
Decision Models
The Excel Calculation Site
www.DecisionModels.com

"Tomer" wrote in message
...
Is it possible to declare a two dimenssion array, with
one dimmension integer on the second boolean? - or do
both dimmension should be with same type of value?
Many thans