Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Declare variables to a code? Pas Excel Discussion (Misc queries) 6 April 10th 10 01:14 PM
Declare Variables in Array Mike H. Excel Discussion (Misc queries) 2 March 11th 09 01:33 PM
Declare and Set Public variables jlclyde Excel Discussion (Misc queries) 2 January 28th 09 03:16 PM
How to efficiently declare variables Jeff Excel Discussion (Misc queries) 2 June 29th 06 01:56 PM
How to declare a dynamic array Peter Rooney Excel Discussion (Misc queries) 4 April 13th 05 01:25 PM


All times are GMT +1. The time now is 09:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"