cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Select Multiple Discontiguous Cells / Ranges / RangeAreas in Excel OfficeJS Javascript Add-in

Select Multiple Discontiguous Cells / Ranges / RangeAreas in Excel OfficeJS Javascript Add-in
15

Upvotes

Upvote
 Aug 23 2022
1 Comments (1 New)
New

In Excel or via VBA, users can select multiple ranges.  However, in the Javascript API, selecting multiple, discontiguous ranges is not available.  I would love for this to be supported please!

 

Currently: 

- RangeAreas does not have a select() function. 

- Workbook does not have a setSelectedRanges function.  

- Range has select(), but does not allow qualifying multiple cells/ranges as a single range: activeWorksheet.getRange("A1, B2").select(); // fails on getRange()

 

Thanks!

Kyle

 

 

Comment
Comments
Jan Karel Pieterse
Silver Contributor
‎Feb 12 2024 07:19 AM
‎Feb 12 2024 07:19 AM

Totally agree. I have an add-in in the store for which I could very much use this feature.

Similar Ideas
No similar ideas