Sheet operation

Using the blocks in the "Sheet" group, you can specify the worksheet to be manipulated or change the name of the worksheet.

Perform one operation on one sheet

If you want to perform only one operation on one sheet of the active workbook (for example, renaming the sheet), drag the block as follows.

• Drag the block to manipulate the sheet.
• Drag the "sheet with index 1 in active workbook" or "sheet with name ... of active workbook" block to "target sheet".
• Specify the sheet number or name.

For example, if you want to change the name of the first sheet to "Table of sheets", drag the block using the following steps.

• Drag the "rename target sheet to ..." block and enter "Table of sheets" in the section where you enter the sheet name.
• Drag the "sheet with index 1 in active workbook" block to "target sheet".

Perform multiple operations on one sheet

If you want to perform multiple operations on one sheet of the active workbook in succession, use the block "process within the block using active sheet in active workbook as the target sheet".
Drag the sheet manipulation block into that block.
Also, if you want to change the target sheet, in the "active sheet in active workbook" section, enter "sheet with index 1 in active workbook" or "sheet with name ... in active workbook".

For example, if you want to change the name of the first sheet to "Table of sheets" and change the tab color to blue, drag the block using the following steps.

• Drag the block "process within the block using active sheet in active workbook as the target sheet."
• Drag the "sheet with index 1 in active workbook" block to "active sheet in active workbook".
• Drag the "rename target sheet to ..." block and enter "Table of sheets" in the section where you enter the sheet name.
• Drag the block "set tab color of target sheet to ..." and select blue in the color selection area.

Working with cells in a specific worksheet

You may want to specify a specific worksheet and manipulate cells within it.
In this case, specify the sheet in the block that operates on cells, such as the "sheet with index 1 in active workbook" or "sheet with name ... in active workbook" in the "Sheet" group. Drag it to the part.

For example, suppose you want to enter 100 in cell A1 in the second sheet in the active workbook.
In this case, drag the block to the workspace as follows:

• Drag the "enter ... in target cell" block in the "Range" group.
• Drag the block "range A1 of active sheet in active workbook" in the "Range" group to the "target cell" section.
• Drag the "sheet with index 1 in active workbook" block from the "Sheets" group to the "active sheet in active workbook" section.
• Rewrite "1" to "2".
• Drag the "0" block in the "Math" group to the value you want to enter and rewrite the value to "100".