MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Creating a variable size array

Posted by lee on January 29, 2002 6:34 AM

How can I create an array in VB with a variable dimension, that depends on the number of column used?

Posted by DK on January 29, 2002 9:18 AM

Just Dim it as Variant. Then when you know in your code how many columns you're going to use, use Redim.