View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default how to redim more than one dimension in a multidimensional dynamic array?

Maybe you need to redefine you perspective.

Do your really need to redim both dimensions? If the real need is to add
rows, then reorient your array to

Arr(1 to num columns, 1 to numrows)

or
use an array of arrays.

--
Regards,
Tom Ogilvy


"lvcha.gouqizi" wrote in message
oups.com...
well, thanks. This is really a weak point of VB.