Quote Originally Posted by mdmackillop
If you don't use Preserve, you clear the array when you redim

[vba]
ReDim Preserve Arr(k - 1, 1)

[/vba]
When I use Preserve I get Subscript out of range error and ReDim Preserve Arr(k - 1, 1) is highlighted.