this is api document provide method
var sheet = Api.GetActiveSheet()
sheet.GetRange('A1:A8').Select()
but i want to togather select multi no-continus cell, eg: ‘A1’、‘A3’、‘B5’
this is api document provide method
var sheet = Api.GetActiveSheet()
sheet.GetRange('A1:A8').Select()
but i want to togather select multi no-continus cell, eg: ‘A1’、‘A3’、‘B5’
Hi @scottluo
Unfortunately, at the moment, there is no support for selecting multiple cells such as ‘A1’, ‘A3’, ‘B5’.
When using GetRange, you can select one cell instead of a range.
Can be a single cell - A1 , or cells from a single row - A1:E1 , or cells from a single column - A1:A10 , or cells from several rows and columns - A1:E10 .