(no subject)

[nonethefewer]

I have this ass-long formula that checks invoice things.  I decided to put it into a function, and just call that function.

The cell:

=determineState()

The function (or at least some of it):

Function determineState()

rowNum = ActiveCell.Row

dateSent = Cells(rowNum, 8)
datePaid = Cells(rowNum, 10)

retVal = "I: "

' Has it been paid?
If datePaid <> "" Then
retVal = retVal & "paid"
Else
retVal = retVal & "sent"
End If

determineState = retVal

End Function

And yet, the result does not refresh well.  If at all.

What the hell?

Comments

[australian-joe.livejournal.com]

Something I've seen and don't always understand: in the cell, try wrapping the function call in curly braces.