EXCEL SET CELL: Difference between revisions
From Macros Wiki
Jump to navigationJump to search
No edit summary |
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
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$