by mor | Dec 31, 2020 | Blog
Do you need to generate Excel reports based on a template on a regular basis? Do you need to copy the template Worksheet to another Workbook, or from another Workbook? Here are some approaches with VBA code Possible use cases for Excel templates Your monthly report is... 
by mor | Dec 24, 2020 | Blog
You are good with Excel. You love it. It gets the job done. You even heard about Macros, or VBA, but pushed it aside. It is not for you, you said to yourself. It is too complicated, you thought. I am here to tell you: it is exactly what you need to do next. Here is... 
by mor | Dec 17, 2020 | Blog
Sometimes writing a short, simple function, can hide in-depth processing that resolves quickly – by calling… itself * What is a recursive function, how does it work, what to be aware of and how it is implemented in Excel VBA – read on… What is a Recursive Function?... 
by mor | Dec 10, 2020 | Blog
I received many questions on The Excel VBA Inner Circle program since it was launched. I summarize here the most frequent questions and my answers to them. Last week I published a Blog post I thought would be all you may need in order to choose the right Inner Circle... 
by mor | Dec 3, 2020 | Blog
The Excel VBA Inner Circle offers a wide range of services to support all Excel VBA enthusiasts. If you just want to start learning Excel VBA or you are a top Excel VBA consultant already – the Inner Circle got you covered. Here is a guide to help you choose the right... 
by mor | Nov 26, 2020 | Blog
A rare glimpse of the “behind the scenes” work on an Excel project. From the raw customer request through the business requirements analysis report up to the delivered solution. Impressions from the first Excel VBA Inner Circle workshop. The first Excel VBA Inner... 
by mor | Nov 19, 2020 | Blog
These days, I am launching a unique home for Excel VBA enthusiasts and professionals. This is a result of a careful examination of the Excel VBA market, constant dialog with customers and years of projects, authoring and teaching. Here is the story of the Excel VBA... 
by mor | Nov 12, 2020 | Blog
Arrays, one of the most flexible, performant and popular data structure in almost any programming language becomes especially useful in Excel. All you need to know about arrays in VBA is right here In case you missed it, the last month in my Blog was dedicated to data... 
by mor | Nov 5, 2020 | Blog
Choosing the right data structures as we plan our program is especially important. Molding our data to be structured to our specific requirements makes our program more readable, maintainable, and efficient. What can we do beyond integer, string, and date? In my last... 
by mor | Oct 29, 2020 | Blog
Why do we need to declare data types for our variables, what purpose does it serve? * Why do some programming languages not care about it too much and what data type are available for us in VBA? What are data types? A data type is a structure to store data with given...
Recent Comments