VBA file path
Display file path to the current workbook In order to create a simple subroutine that shows a path to the active workbook follows…
Category: vba
Count rows in Excel VBA
There are a few methods to count rows and each of them uses VBA. In this example, I’ll show two of them. Range.End…
Compare two columns in Excel and highlight matches
There are a few ways to compare a value in one column with the value in the other column. The first way is…
Activate worksheet with VBA
There are a few ways you can use VBA code to select a worksheet. I’ll show you three ways you can achieve this….
VBA Runtime Error 1004 “Application-defined or Object-defined error”
The VBA Runtime Error 1004 can be caused by many things. In this article, I’ll show a few different situations and show how…
Copy and paste values with VBA
In this lesson, you find multiple examples of how to copy and paste values with VBA. Copy row or column between sheets with…
Assign a macro to a button
In order to assign a macro to a button, first, we need to create a macro. If you don’t know how to do…
Chr 34
CHR is the VBA function and returns the character from the ASCII table. For example, Chr(34) returns 34th character, which is the “ sign (double quotes)….
Inserting a row with VBA
In the lesson about inserting rows and columns, I presented how you can insert a new row in Excel. Here, I will show you…
Deleting a row with VBA
In Excel, you can delete a row by right-clicking on the number of the row and then selecting Delete. But when you want…
