Macro Scheduler 15

XLSetRangeFormat

XLSetRangeFormat>XLBookHandle,SheetName,range,format

 

Not supported in Macro Scheduler Lite.

 

This function requires Microsoft Excel to be installed.

 

Sets the format of a given range.  See Excel documentation for format string placeholders.


Abbreviation: XRF


See also: XLAddSheet, XLCreate, XLDelCol, XLDelRow, XLDelSheet, XLFind, XLGet, XLGetCell, XLGetSheetDims, XLGetSelectedCell, XLGetSheetNames, XLOpen, XLQuit, XLRun, XLRunCode, XLSave, XLSelectRange, XLSetCell, XLSetCellColor, XLSheetToArray 

 

Example

 

XLOpen>%USERDOCUMENTS_DIR%\mybook.xls,1,xlBook

XLFind>xlBook,Sheet1,Widgets,isFound

XLSetRangeFormat>xlBook,Sheet1,A2,#,###.00;[Red](#,###.00);0.00