EXCEL SET CELL: Difference between revisions

From Macros Wiki
Jump to navigationJump to search
Mikeo (talk | contribs)
No edit summary
Mikeo (talk | contribs)
No edit summary
 
Line 12: Line 12:
:EXCEL_SET_CELL 2, 4, "Tool Number 14"
:EXCEL_SET_CELL 2, 4, "Tool Number 14"
<br>
<br>
RowNum = 3
:RowNum = 3
ColNum = 5
:ColNum = 5
CellText$ = "Tool Number 6"
:CellText$ = "Tool Number 6"
:EXCEL_SET_CELL RowNum, ColNum, CellText$
:EXCEL_SET_CELL RowNum, ColNum, CellText$


[[Category:Excel]]
[[Category:Excel]]

Latest revision as of 17:41, 12 January 2011

Up

Command

EXCEL_SET_CELL <row>, <col>, <contents>


Change a cell's contents.

Parameters

<row>
Row number.
<col>
Column number.
<contents>
New cell contents, must be text.

Example

EXCEL_SET_CELL 2, 4, "Tool Number 14"


RowNum = 3
ColNum = 5
CellText$ = "Tool Number 6"
EXCEL_SET_CELL RowNum, ColNum, CellText$