Make your office life easier with simple and fast Excel VBA solutions.
Recently I was working on complex tool, which was doing some actions on Excel cells. In some cases it took a while to process whole example data workbook. Thinking how to speed up the code I asked myself what will be better in case of looping performance – all procedures in one loop or all in separated loops?
Is it possible to store for example color property in VBA array? If yes, which approach is faster – array or standard Excel table?
Watch it here or go to my channel.
Enjoy the video, please leave a like and subscribe!
We often run a macro that connects to SAP, being already logged in it. In this article I’m going to show You how to deal with multiple SAP logons.
We all know that arrays can store values, for example 2 dimensional array can hold standard Excel table. But can arrays store cell color property?
Watch it here or go to my channel.
Enjoy the video, please leave a like and subscribe!
Last time I showed You how to deal with cell values of SAP tables. In today’s post we are going to deal with check boxes in SAP tables.
In the last video I showed You my simple example of progress bar and talked about its advantages. But we didn’t talk about its impact on macro performance and this is the topic of this video. Watch it here or go to my channel.
Enjoy the video, please leave a like and subscribe!