[Custom function] List all sheet’s names

Here is a custom function to list sheet’s names.   Source code   Parameters None   Returns None   References Count sheets Get range object by row and column number Edit cell’s value Get sheet name and sheet id [Custom function] Get sheet name

Edit cell’s value

Here is how to edit cell’s value   Source code   Format   Parameters string … a value to be set   How to get range object Please refer the following posts; Get active range or active cell object Get range or cell object by row and column number Get range or cell object by … Read more Edit cell’s value

Get cell’s value

Here is how to get cell’s value     Source code     Format   Returns value   How to get range object? Get active range or active cell object Get range or cell object by row and column number Get range or cell object by address

Get objects of all sheets

On the other day, I posted a tip to get a sheet object by sheet’s name. If you want to know how to get a sheet object by sheet’s name, please refer the following post; Get a sheet object by name So let’s look into how to get all sheets’ object.   Source code   … Read more Get objects of all sheets

Get Range or Cell object by address

Source code   Format (1) SheetObject.getRange(a1Notation) … Get one or sequential range object by addresses (2) SheetObject.getRangeList(a1Notations) … Get multiple range object by addresses   Parameters a1Notation … Cell address (ex. getRange(A1), getRange($A$1), getRange($A:$B), getRange($1:$2) …) a1Notations … Cell address (ex. [‘A1:D4’, ‘F1:H4’])   Returns Range object   Sample code

Get Range or Cell object by row and column number

Source code   Format (1) SheetObject.getRange(row, column) … One range object (2) SheetObject.getRange(row, column, numRows) … Multiple ranges’ objects (1 column and multiple rows) (3) SheetObject.getRange(row, column, numRows, numColumns) … Multiple ranges’ objects (multiple column and multiple rows)   Parameters row … start row number to get column … start column number to get numRows … Read more Get Range or Cell object by row and column number

Get active range or active cell object

Source code   Format (1) SheetObject.getActiveCell() … Get active cell object (2) SheetObject.getActiveRange() … Get active range object (3) SheetObject.getCurrentCell() … Get active cell object   Returns Range object

Add a sheet

Here is how to add a sheet. There are 8 functions to achieve this.   Source code   Format SheetObject.insertSheet(sheetName, sheetIndex, options)   Parameters (1) sheetName … You can edit new sheet’s name (2) sheetIndex … You can edit a target position to be added (3) options … you can select a original sheet to … Read more Add a sheet