Juniper Systems Allegro CX Manual - Manual (Page 177)

Allegro CX Owner’s Manual 177
Modifi ed([onOff])
Returns true if the Modifi ed fl ag is true (workbook was modifi ed)
and sets the Modifi ed fl ag to onOff (true or false).
Example:
Modifi ed(false)
MsgBox(text)
Shows the Message Box with the text.
Example:
MsgBox(“Hello”)
Paste([contents, format, skipBlanks, onlyResults])
Pastes the clipboard to the current selection.
Example:
Sel(A1:A5)
Copy()
Sel(B1)
Paste()
All arguments are optional. Paste() function without arguments
works as Edit|Paste menu command. The Paste() function with
arguments works as Edit|Paste Special menu comment. The Default
values for arguments are Paste(true, true, false, false).
Example for paste contents, preserve previous format:
Paste(true, false)
PlaySound([fi lename])
Plays a sound (fi le of type *.wav). If you use this function without
parameter, any currently playing sound is stopped.
Example:
PlaySound(“Song1.wav”)
RangeRef(col1, row1, col2, row2 [, sheetIndex])
Returns the range reference.
Example:
MsgBox(Sum(RangeRef(a1,2,20,2)))