Welcome to Simple Excel VBA

If You’d like to learn useful tricks in VBA in Excel and not only, You have come to the right place.

I invite you to Posts tab to read the latest entries. If You would like to search for articles You are interested in, use the search engine on this website and You will definitely find something in your area. There are articles on both simple and really advanced topics.

If you would like to just look at ‘funny’ pictures in the memes style, please visit the Memes tab. Maybe thanks to them you will be interested in the article they are in.

To contact me, go to About me or Contact me.

Recent posts:

Split array to increase performance

I already made article about how fast arrays can be comparing to Excel tables. You know that. You know also that arrays need some RAM memory to exist. But can we increase array performance with its split and descrease RAM usage? In this article I will show You if it is possible.

(more…)
Tomasz Płociński

Author: Tomasz Płociński

Excel VBA enthusiast who is also open for other languages. Mainly working in VBA, some SQL, hungry for more.

Issue with UCase, LCase, Format, Mid etc in VBA

The most known situation in office environment – it was working on my computer, it is not on other. This time appeared compile error Can’t find project or library, but showing me UCase issue with highlighted code line. How code could loose the library for the basic VBA function?

(more…)
Tomasz Płociński

Author: Tomasz Płociński

Excel VBA enthusiast who is also open for other languages. Mainly working in VBA, some SQL, hungry for more.

Prevent from importing missing references

Working as VBA developer brings a lot of different issues. One of the obstacles is the Office version. Apart of various behaviours of the same thing, there always will be something new, which was not avaiable in the previous version. In this article I’m going to show You how to prevent from importing missing references.

(more…)
Tomasz Płociński

Author: Tomasz Płociński

Excel VBA enthusiast who is also open for other languages. Mainly working in VBA, some SQL, hungry for more.