Don't see why VBA compiler says --> Compiler error Expected:"="

[Semanon]

Hi,

I would expect this is it was regarding a 'function' call but it's for a 'sub'. I'm trying to execute "createSomeLunchBreaks "...

            If (agentsOnBreak \ 13)  < Num_Agents_Per_Break Then
             
                createSomeLunchBreaks (lunchDuration, _
                                         agentRow, dateCol, _
                                         longLunchAgents, theName)

This is the sub that is executed by above ...

Sub createSomeLunchBreaks(lunchDuration As Integer, _
                                agentRow As Integer, _
                                dateCol As String, _
                                longLunchAgents() As String, _
                                theName As String)
   
    If break_length = longLunchDuration Then
        addLongBreak
    Else
        addShortBreak
    End If
        
End Sub

Any clues much appreciated

 

[Norie]

Remove the brackets in the call to the sub.

         createSomeLunchBreaks lunchDuration, _
                                         agentRow, dateCol, _
                                         longLunchAgents, theName