If I use
it works OK, but the following function gives the Error "Unable to get the Mode property of the Worksheetfunction class".
Can somebody help to solve it out?
Thank you in advance!
Code:
?WorksheetFunction.Mode(Array(1,2,5,8,12,13,1,1))
Code:
Function Mode(strString As Variant)
'?Mode("1,2,5,8,12,13,1,1")
Dim VarOut As Variant
VarOut = Array(Split(strString, ","))
Mode = WorksheetFunction.Mode(VarOut)
End Function
Thank you in advance!