Does Excel need optimization ?
Automatic code profiling
You want to learn Google Apps Script?
Learning Apps Script, (and transitioning from VBA) are covered comprehensively in my my book, Going Gas – from VBA to Apps script, All formats are available from O’Reilly, Amazon and all good bookshops. You can also read a preview on O’Reilly