it works for me ( because when i remix it, the google sheet is a replaced with a dummy local DB which i had to edit to add meaningful content).
can you try this (temporary) change , it will replace the header of gkt1 with some numbers - i have a feeling the number of rows does not reflect actual # of rows. did you actually delete rows beyond 3 from the sheet?
I highlighted and deleted row 4 - 50 but evidently there was something there. I created a new sheet and copied the cells to it and pointed all variables to the new sheet and it works again. Well that was a whole day wasted lol.
Thanks for the help everyone. It is working again. Now I will know if it fails in the future it may be a DB issue.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.