Hi All,
I have a function that I want to export as an array. I've limited the code to the Type Mismatch error
The error comes at the end function, the locals window shows the results as intend so I can't work out the issue
Many Thanks for any help.
I have a function that I want to export as an array. I've limited the code to the Type Mismatch error
Code:
Public Function BatchProductionVial1(DrugName As String, DrugRoute As String, DrugDose As Double, DrugBatchSize As Integer) As Variant
Dim returnVal(3) As Variant
returnVal(0) = DrugName
returnVal(1) = DrugRoute
returnVal(2) = DrugDose
returnVal(3) = DrugBatchSize
BatchProductionVial1 = returnVal
End Function
The error comes at the end function, the locals window shows the results as intend so I can't work out the issue
Many Thanks for any help.