vba Archives | Page 17 of 18

VBA Check if File Exists

Check if a file exists In VBA, you can check whether the file or a directory exists by using the Dir method. Look…

Display file path to the current workbook In order to create a simple subroutine that shows a path to the active workbook follows…

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…

There are a few ways to compare a value in one column with the value in the other column. The first way is…

There are a few ways you can use VBA code to select a worksheet. I’ll show you three ways you can achieve this….

The VBA Runtime Error 1004 can be caused by many things. In this article, I’ll show a few different situations and how to…

In this lesson, you find multiple examples of how to copy and paste values with VBA. Copy row or column between sheets with…

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 is the VBA function and returns the character from the ASCII table. For example, Chr(34) returns the 34th character, which is the “ sign (double…

In the lesson about inserting rows and columns, I presented how you can insert a new row in Excel. Here, I will show you…