Juniper Systems Allegro CX Manual - Manual (Page 171)

Allegro CX Owner’s Manual 171
Calling a Procedure
You can structure your code into more simple tasks and then you can
call previously defi ned task from within a task using its name.
Example:
Set(a1,100)
while a1>0
Hello
Set(a1, a1-1)
end
Comments
Set(a1,100) ‘Note: set cell A1 to value 100
Automating Tasks Functions Reference
Parameters in [ ] are optional.
ActiveCell()
Returns the active (highlighted) cell.
Example:
Set(ActiveCell(), “Hello World!”)
ActiveSheet([index])
Returns the number of the active sheet (1-based) and selects the new
one if index is specifi ed. Returns “!!Val” if index is less than 1 or
greater than number of sheets.
Example: ActiveSheet(2)
Beep([soundType ])
Plays a waveform sound. SoundType specifi es the system sound
type (64 – asterisk, 48 – exclamation, 32 – question, 16 – hand, no
parameter – default sound).
Example:
Beep()
Beep(32)
CellRef(col, row [, sheetIndex])
Returns the cell reference.
Example:
Set(CellRef(a1,2), 123)