Google Apps Script VBA equivalents

When converting from VBA, unless you are abandoning VBA, it's just as well to mimic some of the functions that are missing from GAS so that you can minimize your script Conversion work. Here is a selection of useful ones for quick reference. Since javaScript is case sensitive, be careful that you get it right. I have retain the official VBA convention for case for existing (mimicked) VBA functions, rather than the usual javaScript convention.


This code is at, and the shared Google Apps Script Library can be accessed with the key MEQ3tE5y5_cTOAgUbUKSIAiz3TLx7pV4j


Take a look at  From VBA to Google Apps Script for more like this.. In the meantime why not join our forum,follow the blog or follow me on twitter to ensure you get updates when they are available.  

Transitioning is covered more comprehensively in my my book, Going Gas - from VBA to Apps script, available All formats are available now from O'Reilly,Amazon and all good bookshops. You can also read a preview on O'Reilly. It also comes with an extensive VBA-Apps Script equivalence library.