Re: [users] Assigning Data to Cells in Automatic Mode

2006-03-14 Thread CPHennessy
On Mon March 6 2006 21:43, + Andrew R wrote: > [ MODERATED ] *** > I am trying to write a routine in Calc (part of a Macro) to replace the > numeric contents of one cell with that of anotherr 'if' a certain condition > is met (If...Then...Endif). The equivalent statements in

Re: [users] Assigning Data to Cells in Automatic Mode

2006-03-06 Thread Ross Johnson
On Mon, 2006-03-06 at 16:43 -0500, Andrew R wrote: > I am trying to write a routine in Calc (part of a Macro) to replace the > numeric contents of one cell with that of anotherr 'if' a certain condition > is met (If...Then...Endif). The equivalent statements in Excel would be: > > =Select (!A1

[users] Assigning Data to Cells in Automatic Mode

2006-03-06 Thread Andrew R
I am trying to write a routine in Calc (part of a Macro) to replace the numeric contents of one cell with that of anotherr 'if' a certain condition is met (If...Then...Endif). The equivalent statements in Excel would be: =Select (!A1) =Copy() =Select(!B1) =Paste() =Cancel.Copy A simple altern