The copyright window is the information, which is popping up when You are changing the language of your sessions. In this article I’m going to show You the simple trick of how to avoid this copyright window in SAP.
Continue reading “How to manage with copyright window in SAP”Category: Excel VBA
Video tutorial: How to declare array in Excel VBA
In this video I’m presenting to You three methods, which I’m mainly using in my codes – array as range, loop to array and array as words list.
Watch it here or go to my channel.
Enjoy the video, please leave a like and subscribe!
Looping performance 2 – can I speed it up?
After last tests I was not so surprised, but still proud of myself that found the difference between all in one loop and separated. However, I still felt a bit unsatisfied with possibly existing, other solutions and speed up looping performance. That’s why I decided to implement further modification.
Continue reading “Looping performance 2 – can I speed it up?”Video tutorial: Change variables value in array
There are variables put inside array. Will variables value change, if array values change?
Watch it here or go to my channel.
Enjoy the video, please leave a like and subscribe!
Looping performance – all in one or separated loops?
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?
Continue reading “Looping performance – all in one or separated loops?”Video tutorial: Store color property – array vs table speed comparison
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!