How to Use Vbcrlf in VBA
Vbcrlf, also known as the “Visual Basic Carriage Return Line Feed”, is an essential built-in constant in the Visual Basic for Applications (VBA)…
Category: vba
How to Find the Chart Name in Excel VBA
Here’s a tutorial that covers how to find the names of charts in Excel via VBA (Visual Basic for Applications). This useful task…
How to Search Data in Google Using Excel VBA
In this tutorial, we will explore how to use Excel VBA to search for data from Google. VBA, or Visual Basic for Applications,…
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…
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,…