Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Declare variables to a code? | Excel Discussion (Misc queries) | |||
Declare Variables in Array | Excel Discussion (Misc queries) | |||
Declare and Set Public variables | Excel Discussion (Misc queries) | |||
How to efficiently declare variables | Excel Discussion (Misc queries) | |||
How to declare a dynamic array | Excel Discussion (Misc queries) |