2010-01-27

nonethefewer: (Default)
2010-01-27 02:04 pm
Entry tags:

(no subject)

"What's spam?"
nonethefewer: (Default)
2010-01-27 02:25 pm
Entry tags:

(no subject)

"So you shouldn't have to unplug your mouse to plug in your speakers."
nonethefewer: (Default)
2010-01-27 06:03 pm

(no subject)

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?