beautypg.com

Juniper Systems Allegro CX Manual User Manual

Page 177

background image

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