Tag Archives: google script

google script equivalent of xlDown, xlRight

I recently started creating scripts for google spreadsheet documents, the javascript based scripts. Unfortunately, I could not find the equivalent of xls vba range(“A1”).end(xlDown) in native google script functions. As such I created a working js equivalent. Only issue with it is performance. It is not really fast, but this is more due to Apps Script rather than the code itself or the fact that it is written in js. In case someone find a native equivalent to this function, please do not hesitate to share. /** * V0.2 => PERF IMPROVED * * Home-made equivalent of xls range().end(xlToRight) function […]