How to protect your VBA Code / Project from an Unauthorized access?
Protecting your VBA scripts may seem a little extreme, especially with so many IT experts now recognising the value of open source and free access but it does have a… Read more »
Monthly Archives: July 2016
Which chart or graph is a good fit for you?
Choosing the right type of chart or graph visualization can be key to conveying the most important insights in your data on sight. This article will help you determine which… Read more »
What is so good about VBA?
Here is why I think VBA is so great, but first let’s try and define VBA. A tightly integrated application automation system that allows professionals from non software development disciplines… Read more »
How to Compare Word Documents using Word VBA?
Word Documents are everywhere – proposals, tenders, notes, technical papers. In many cases there are more than one authors and more than five reviewers. Just in case you get a… Read more »
A trick with MONTH() Function in Excel
I guess we are all familiar with the MONTH function in Excel. If you give it a date as an argument, it will return the month number. So far so… Read more »
When to use Multi-Cell Array Formulas
Excel Multi-cell array formulas are a single formula which returns multiple values and is entered into multiple cells. Hence ‘multi’ in the name. Let’s look at an example, say we… Read more »
How to enter same Formula in multiple cells?
As you probably know, there are a TON of ways to copy or fill formulas. I am going to show you the technique that works best when you already have… Read more »