I want to put an 'x' in Calc cells based on whether another cell's date
(totalincoming) is larger than a different cell's value.
I started this macro but is there an easier way?
How do I set a cell's value?
REM ***** BASIC *****
' put an 'x' in cells where totalincoming (06:41:45) is greater or equal
to flatrateincoming (06:36)
Sub Main( totalincoming As Date, flatrateincoming as Date )
Option Explicit
dim cellcontents as string
If totalincoming >= flatrateincoming Then
cellcontents = "x"
End If
' set current cell's value
End Sub
--
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help
