123 reputation
118
bio website
location
age
visits member for 4 years
seen Nov 4 at 17:21

2d
awarded  Famous Question
Nov
4
comment Get Google Search to display full page titles
"some extension" -- got anything beyond that?
Nov
4
revised Get Google Search to display full page titles
added 29 characters in body
Nov
4
asked Get Google Search to display full page titles
Mar
20
awarded  Popular Question
Jul
30
awarded  Critic
Jul
25
accepted Set up a forwarding email account with Gmail for Business
Feb
21
awarded  Scholar
Feb
21
accepted how do I get named ranges in Google Spreadsheets to be more reliable/current?
Feb
20
comment how do I get named ranges in Google Spreadsheets to be more reliable/current?
So the real issue here was that the app doesn't like to do lots of get named range calls -- I had about 60 cells that were relying on a function that read and stored a set of values from a named range. Well that caused all sorts of problems, so I had to ditch it.
Feb
18
comment how do I get named ranges in Google Spreadsheets to be more reliable/current?
Hmm, taking out ss.getActiveSheet doesn't seem to have changed anything. I'm going to have to look at the original sheet later...
Feb
18
comment how do I get named ranges in Google Spreadsheets to be more reliable/current?
so the only difference I see is this: var sh = ss.getActiveSheet();, could that be it? I added that to my code (and cleaned up a typo) and it seems to be working.
Feb
18
comment how do I get named ranges in Google Spreadsheets to be more reliable/current?
OK your sample is working and mine isn't, I'll look into it a bit.
Feb
18
comment how do I get named ranges in Google Spreadsheets to be more reliable/current?
I don't see the difference between what I'm doing and that code.
Feb
18
comment how do I get named ranges in Google Spreadsheets to be more reliable/current?
Sorry, I don't understand that. I made a sample spreadsheet to show you what I'm encountering: docs.google.com/spreadsheet/…; that's a simple spreadsheet with one named range and a function that accesses it. The function can't find the named range.
Feb
18
comment how do I get named ranges in Google Spreadsheets to be more reliable/current?
As in, do they use $A$1 or A1? It's the latter. Don't know why that'd matter, the data in them changes rarely.
Feb
17
awarded  Editor
Feb
17
revised how do I get named ranges in Google Spreadsheets to be more reliable/current?
edited title
Feb
17
asked how do I get named ranges in Google Spreadsheets to be more reliable/current?
Nov
22
awarded  Notable Question