ReDim Preserve

[Blobajob88]

Hi,

I'm looking to set an array as below
Dim Arr() As Variant
Arr = Range("B7").CurrentRegion

Then I want to remove some items and resize the array whilst also retaining the values but what I've done below is giving me an out of range error. can someone explain why it won't work?

ReDim Preserve Arr(1 To 40, 1 To 30)

 

[RoryA]

If you use Preserve, you can only change the upper boundary of the last dimension of the array.