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
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
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