Is it possible to ReDim a matrix? I am trying to do just that but I get the
error message that Matrix dimension already set. Please need help!

Hi Arne,

Is it possible to ReDim a matrix? I am trying to do just that but I get the
error message that Matrix dimension already set. Please need help!

Yes, but to be able to do that you need to change your declaration to:

Dim MyMatrix() as Variant/Long/String/Double/.....

(i.e. omit the size info between the brackets).

Check Help on the ReDim statement. It reads somewhe

Remarks

The ReDim statement is used to size or resize a dynamic array that has already
been formally declared using a Private, Public, or Dim statement with empty
parentheses (without dimension subscripts).



Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com