{{getMsg('Help_YouAreHere')}}: / {{page.title}} {{page.title}}

Redim Preserve operator x(n)basicsyntax

Resizes the array x to the size y. The original values will be preserved.

Redim Preserve x(n)

The array with the new size.

Dim x() As Number
x =Array(1,2,3)
Redim Preserve x(4)
-> x=[1,2,3, ]

Dim monthOfFirstQuarter() As String
monthOfFirstQuarter = Array("January", "February", "March")

Redim monthOfFirstQuarter(4)

monthOfFirstQuarter(4) = "April"
' The array now contains: ("January", "February", "March", "April")

formula = "March" In monthOfFirstQuarter and "April" In monthOfFirstQuarter