Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function onEdit(e) {
- var cfg = { // Please set this object.
- A5: {startRow: 6, endRow: 19},
- A19: {startRow: 20, endRow: 23},
- };
- var activeRange = e.range.getA1Notation();
- var ranges = Object.keys(cfg);
- if (cfg[activeRange]) {
- var sheet = e.source.getActiveSheet();
- var values = sheet.getRange(ranges[0] + ":" + ranges[ranges.length - 1]).getValues();
- values.forEach(function(e, i) {
- if (e[0]) {
- sheet.showRows(cfg[ranges[i]].startRow, cfg[ranges[i]].endRow - cfg[ranges[i]].startRow);
- } else {
- sheet.hideRows(cfg[ranges[i]].startRow, cfg[ranges[i]].endRow - cfg[ranges[i]].startRow);
- }
- });
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement