Arrays in VBA

[sammy]

Hi can anyone please tell me what the maximum size an
array can be without dieing?! I may need something as big
as (3500,8)? Is this possible or perhaps there is an
easier way?

MORE INFO - NOT NECESSARY READ
Basically I need to capture about 3500 Brand Items and
assign 8 traits to each Brand Item (sales, units, sales
VYA etc..). I'm thinking of doing this so i can then
analyse the data easily...

Thanks!

 

[Bernie Deitrick]

Sammy,

Read the MS Knowledge Base article here:
http://support.microsoft.com/default.aspx?scid=http://support.microsof
t.com:80/support/kb/articles/q166/3/42.asp

HTH,
Bernie
MS Excel MVP

 

[Bernie Deitrick]

Sammy,

Sorry, that one was about array formulas on worksheets.

The correct answer is at

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q177991

HTH,
Bernie
MS Excel MVP