View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
dsh dsh is offline
external usenet poster
 
Posts: 5
Default Dynamic multi-dimensional array

I need to dynamically set the number of dimensions and elements, not the
values of the elements. The dimensions and elements are dynamic, i.e. they
change. So I need a way programmatically to easily change these. arr() may
be arr(5, 6, 10) or arr(1, 2, 9, 4), etc. etc.

"Dave Peterson" wrote:

Dim Arr as variant
arr = array(5,6,10)



DSH wrote:

Is it possible to create a dynamic multi-dimensional array? I know the
following will not work, but something to the effect:

dim arr()

dim s as string

s = "5, 6, 10"

redim arr(s) 'i.e. redim arr(5, 6, 10)

Thanks.


--

Dave Peterson
.