I have a Google sheet in which I created a custom show/hide columns function in the Script Editor. I want to show/hide columns 1, 3, and 14 through 30.
This is the code I tried:
var colsCheck = [1,3,14:30];
But when I save, I get this error:
Missing ] after element list. (line 4, file "Code")
So I tried this:
var colsCheck = [1,3,14-30];
This doesn't give an error but it doesn't hide columns 14-30, either. Is there a way to indicate I want columns 14 through 30 without typing
14, 15, 16, 17...?
I am trying to Google this but I don't know the terminology well enough to find what I'm looking for.