Multiple sheet select

[s3nsei 0]

Good day,

Please help, i'm trying to select multiple excel sheet, as in manual, i hold down ctrl button and just clicked the sheet 1,2,3

Is it possible to do that with autoit script?

Thank you..

[water 1,827]

It's possible.

$oExcel.Sheets("sheet1").Select
$oExcel.Sheets("sheet2").Select(False)

Will select "sheet1" and "sheet2". Or you can select by sheetnumber:

$oExcel.Sheets(1).Select
$oExcel.Sheets(3).Select(False)

[s3nsei 0]

It's possible.

$oExcel.Sheets("sheet1").Select
$oExcel.Sheets("sheet2").Select(False)

Will select "sheet1" and "sheet2". Or you can select by sheetnumber:

$oExcel.Sheets(1).Select
$oExcel.Sheets(3).Select(False)

Hello Water,

Thanks for your help as always, really appreciate

But i still can't select both sheet, please check below code and kindly advise

Below code doesn't select group, but it select one by one (in manual, clicked without control pressed)

$aArray = _ExcelSheetList($oExcel)

_ExcelSheetActivate($oExcel,$aArray[0])

For $i = $aArray[0] To 2 Step -1

$oExcel.Sheets($i).Select

Next

[water 1,827]

Be sure to use the parameter for Select:

$aArray = _ExcelSheetList($oExcel)
_ExcelSheetActivate($oExcel,$aArray[0])
For $i = $aArray[0] To 2 Step -1
  $oExcel.Sheets($i).Select(False)
Next

[s3nsei 0]

Be sure to use the parameter for Select:

$aArray = _ExcelSheetList($oExcel)
_ExcelSheetActivate($oExcel,$aArray[0])
For $i = $aArray[0] To 2 Step -1
  $oExcel.Sheets($i).Select(False)
Next

Yey, thanks m8, it worked!

You're amazing, Thanks a lot!

[water 1,827]