Jan. 27th, 2010
(no subject)
Jan. 27th, 2010 06:03 pmI have this ass-long formula that checks invoice things. I decided to put it into a function, and just call that function.
The cell:
The function (or at least some of it):
And yet, the result does not refresh well. If at all.
What the hell?
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?