Sub Array2() Dim Data(10) As Integer Dim Message As String, i As Integer For i = LBound(Data) To UBound(Data) Data(i) = i Next i MsgBox "Upper Bound = " & UBound(Data) & vbCrEnd Sub