Move Column Using Excel VBA
As you are probably aware by now, anything that can be done in Excel, either automatically or manually, can be done through Visual…
Category: vba
Merge and Unmerge Cells using Excel VBA
Although Excel is a great tool for automating your work, Visual Basic for Applications (VBA) is even better tool to achieve this. All…
Checking for Non-Empty Values in VBA
With Excel formulas, we are already automating our work. Adding VBA to this, we can get repetitive actions automated. We can find the…
Excel VBA Hyperlinks – Linking, Following, and Managing
With Excel VBA, you can create hyperlinks that allow users to navigate effortlessly to specific locations within the same worksheet, other worksheets, or…
Using INDIRECT Function in VBA
There are specific formulas that can be used in Excel without VBA, but there can be more useful when used in VBA. Such…
Save a Text File with UTF-8 Encoding in VBA
There are a lot of saving options in Excel, and we can manipulate the saving options as well as any other. When it…
Pattern Matching in Excel
When we speak about pattern matching in Excel, we usually mean the process of searching for certain patterns or characters in a column,…
Copy Dynamic Range in Excel Sheet Using VBA
When dealing with VBA, as it is basically a programming language, you will hear the terms „hard-coded“ and dynamic. When we discuss these…
Delete Empty Rows in Excel with VBA
There are often situations when certain things cannot be done in Excel and must be automated in VBA. Of course, we can always…
Print Range to an Array in VBA
When speaking about Excel, we have to know the difference between arrays and ranges. The main difference is that array is a collection…
