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 alternative would be: "B1=A1". Possible alternatives could be: Move/Assign/Goto/Replace/EQ, etc. Similar functions in O.O. seem to have limited functionality and confined to textual data. _________________________________________________________________ Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
