View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike H. Mike H. is offline
external usenet poster
 
Posts: 471
Default Declare Variables in Array

If I wish to dimension this array: DataArray(300,4) and I know this:
1st element of second dimension will be long
2nd element of second dimension will be string
3rd element of second dimension will be integer
4th element of second dimension will be variant (maybe string, maybe long,
etc).
All elements of first dimension would be variant

The way I currently dim this is:
Dim DataArray(300,4) as variant
Can I precisely dimension this array? How? Thanks.