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…
Category: vba
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…
