Clear Selection in VBA
As you are probably aware, Visual Basic for Application (VBA) has virtually limitless options for automating Office files, especially Excel. When writing our…
Category: vba
Clear Memory in VBA
The Excel VBA Out of memory error (Run-time error 7) occurs when Excel runs out of system resources to continue running the macro….
Use Xlookup in VBA
You have probably heard about Vlookup and Hlookup functions in Excel. Vlookup is short for Vertical Lookup. With it, we can search for…
Add Data to Table Using VBA
We can use Excel VBA to insert rows and columns into an Excel table and add data to the table. In this tutorial,…
Change Text in Cell Using VBA
You probably already know that the VBA (Visual Basic for Application) is one of the greatest tools at our disposal for automating and…
Excel VBA Clear Clipboard
When we use a macro to copy and paste data in Excel, it is good practice to clear the clipboard after the operation….
Check If A File Is Open or Closed in Excel
When writing code in Excel VBA it is a good practice to first check for some conditions before taking certain actions. For example,…
Concatenate Array Using VBA
Concatenation is the process of joining two or more text strings to form one text string. Excel has the CONCATENATE function that can…
Run VBA from Command Line
To Run an Excel VBA macro from the command line has the advantage of convenience. With a few simple keystrokes, we can execute…
Vlookup in VBA
Excel VLOOKUP function looks for a value in the leftmost column of a table and then returns a value in the same row…