Compile Error: Sub or Function not defined - Excel Function definition

Question

I'm trying to define the following function but am getting Compile Error: Sub or Function not defined. The debugged is highlighting the first line. Any ideas as to what could be incorrect here?

Function MAXELSEMIN(A As Integer, B As Double, C As Double) As Double
If A = 1 Then
    test = Max(B, C)
ElseIf A = -1 Then
    test = Min(B, C)
Else
    test = 0
End If
End Function

BigBen · Accepted Answer · 2020-07-06 22:31:57Z

1

Use the WorksheetFunction object to call the functions in question:

test = WorksheetFunction.Max(B, C)

test = WorksheetFunction.Min(B, C)

and then at the end add the line:

MAXELSEMIN = test

edited Jul 6, 2020 at 22:31

answered Jul 6, 2020 at 22:26

BigBen

50.4k7 gold badges29 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Compile Error: Sub or Function not defined - Excel Function definition

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related