Skip to content

Instantly share code, notes, and snippets.

@kinuasa
Last active July 10, 2020 05:20
Show Gist options
  • Save kinuasa/3abfe307a06131f5ad81ab58691ea383 to your computer and use it in GitHub Desktop.
Save kinuasa/3abfe307a06131f5ad81ab58691ea383 to your computer and use it in GitHub Desktop.
Office Scripts
//次のシートを取得
function main(workbook: ExcelScript.Workbook) {
let currentSheet = workbook.getActiveWorksheet();
let sheet = currentSheet.getNext(); //メソッドの引数にtrueを指定すると非表示のシートをスキップ
sheet.getRange("B2").select(); //セルB2を選択
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment