Jan. 27th, 2010

nonethefewer: (Default)
"What's spam?"
nonethefewer: (Default)
"So you shouldn't have to unplug your mouse to plug in your speakers."
nonethefewer: (Default)
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?
Page generated Jun. 23rd, 2025 10:13 am
Powered by Dreamwidth Studios