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 -- ----------------------------------------------------------------- To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help