Contents |
Go to and select specified row and column
1. dlgRowColGoto r1:=10 c1:=2;
2. dlgRowColGoto r1:=10 c1:=2 wks:=[book1]sheet1;
| Display Name | Variable Name | I/O and Type | Default Value | Description |
|---|---|---|---|---|
| Go to Row | r1 |
Input int | |
It specifies the row number to go. |
| Go to Column | c1 |
Input int | |
It specifies the column number to go. |
| Worksheet | wks |
Input Worksheet | |
It specifies the name of worksheet. |
| Extend Selection | select |
Input int | |
This is only available when you have selected one or more regions. It specifies whether or not to extend the selection from the last region that you choose. The default setting is 0. |
This function is used to go to specified row and column. Please note that when you use Extend Selection, if multiple regions are selected, only last region will be extended.
If you want to go to the 3rd row in column 2 of sheet1 in book2, you can use the following command:
dlgRowColGoto r1:=3 c1:=2 wks:=[book2]sheet1.