How does SetArray not work? Are you getting a compile error, a runtime error, or no errors but unexpected results? If you still can't get SetArray to work, you could do something like this:
Private Sub InitializeArray(data() As Double, value As Double)
Dim i As Integer
Dim lowerBound As Integer
Dim upperBound As Integer
lowerBound = LBound(data)
upperBound = UBound(data)
For i = lowerBound To upperBound
data(i) = value
Next
End Sub
- Elton