We have made a significant update to the VBA Macro Engine in Zoho Sheet. Your macros could now run faster by up to 75% than before, depending on what your macro does.
Try the sample spreadsheet embedded below which uses Macros to generate Vicsek Fractals – a nice recursive pattern. Click on the ‘Generate Fractal’ button in each worksheet to generate different fractals. You can also change the number of iterations on the spreadsheet and generate the fractal again. Use the ‘Click to Edit’ button if you want to change the number of iterations.
Learn more about this enhancement on our discussion forum.
Going forward, we will add more features to our Macros functionality
such as User Defined Functions, HTTP requests, and more. Let
us know what features in Macros, you would like to see in Zoho Sheet.