What Application.Screenupdating = False Means and Why is it Used in VBA

Ok! This one is important. Any good VBA procedure always has this line mentioned at the beginning. Application.Screenupdating=FALSE And bef...

VBA variables in Excel

In this article we will learn about what are different types of variables used in VBA and how to use them. What are VBA variables ? VBA stands f...

Operators in Excel VBA

The signs and keywords we use to operate variable in VBA are called VBA Operators. For example, in the lines below lines =, +, >, & are operato...

How to Declare VBA Constants in Excel

The Pi's value is 3.14, the gravitation pull of the Earth is 9.8 m/s2, you have an interest in VBA, etc. These all are constants and they don't change...

Excel VBA Variable Scope

In all the programming languages, we have variable access specifiers that define from where a defined variable can be accessed. Excel VBA is no Except...

VBA Select Case: An Alternative of Multiple If Else If Statements

When you have many conditions to check or you want to do some operation on the basis of the choice of the user, then you may use If Else If statements...

Split Excel Sheet Into Multiple Files Based On Column Using VBA

Do you have a big data on excel sheet and you need to distribute that sheet in multiple sheets, based on some data in a column? This very basic task b...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.