This section describes how to pass arguments when procedures are separated. In the article below, I mentioned that it is easier to read and process the code by separating the procedures...

Struggling with cell misalignment or manual resizing in Excel? This article shows how to efficiently adjust row height and column width using VBA—solved in just a few lines of code by a seasoned macro expert.

We show you how to search through the data from the top down, and how to start from the bottom row of the Excel file and work your way up.

In many cases, it is useful to be able to get the location of the Excel file you are currently working on when you want to retrieve values from another Excel file or save a file as a name using a macro. In this article, we will show you how to use the "Path" command, which is useful in such cases. The currently open Excel file...