On 07/04/11 13:34, RA Brown wrote:
James wrote:
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
Being a bit nit-picky here. This that a date or time? There is a
difference.
Andy
Time of the form hh:mm:ss
--
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help
