View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
ahmadifx ahmadifx is offline
external usenet poster
 
Posts: 2
Default Adding rows to a 2 dimensional array ...

Hi,
Try using the statement ReDim Preserve .. It might solve.. Im not sure bcos
it works in VB dono about VBA
--
Regards
Ahmad
Microsoft Student Partner - India


"netnews.comcast.net" wrote:

Is it possible to add rows to a two dimensional array? I have a situation
where the number of rows can be different each time the array is used. I
need to preserve the existing data in the array when adding the additional
rows. I am using Excel 2003. Any help will be very much appreciated.

Thanks in advance,
Ralph Fraley