P
pinkfloydfan
Hi there,
I wonder if anybody can explain to me why I am getting the #VALUE!
error here.
I have a function GetSimMinValue which accesses another function
MinValue built into a class module, the first function is:
Function GetSimMinValue(Identifier As Integer, Step As Integer) As
Double
GetSimMinValue = Simulations(Identifier).MinValue(Step)
End Function
This function accesses the following function in the class module:
Public Function MinValue(Step As Integer)
Dim i As Long
Dim Mins() As Double
ReDim Mins(1 To 1, 1 To 2)
' code here to set the values of Min()
MinValue = Mins
End Function
Having stepped through the function everything works fine until the
final line: MinValue=Mins which seems to be causing the error.
Does anybody have any ideas why?
Thanks in advance
Lloyd
I wonder if anybody can explain to me why I am getting the #VALUE!
error here.
I have a function GetSimMinValue which accesses another function
MinValue built into a class module, the first function is:
Function GetSimMinValue(Identifier As Integer, Step As Integer) As
Double
GetSimMinValue = Simulations(Identifier).MinValue(Step)
End Function
This function accesses the following function in the class module:
Public Function MinValue(Step As Integer)
Dim i As Long
Dim Mins() As Double
ReDim Mins(1 To 1, 1 To 2)
' code here to set the values of Min()
MinValue = Mins
End Function
Having stepped through the function everything works fine until the
final line: MinValue=Mins which seems to be causing the error.
Does anybody have any ideas why?
Thanks in advance
Lloyd