I want to get the selected range after adding or deleting multiple rows and columns in Google Sheets using Google App Script. The added or deleted rows may not be contiguous. How can I achieve this?
For example, if I delete columns 3 and 5, I want to get the range of deleted columns as 3, 5. Similarly, if I add rows 2 and 4, I want to get the range of added rows as 2, 4.
I have tried using getActiveRange() and getActiveRangeList() but they only give me the last selected range. How can I get all the selected ranges?