Tag Archives: Hire VBA Programmer

No Thumbnail

Searching Data In Excel Sheets

One of the main tasks an Excel VBA programmer encounters is  searching excel sheets for a specific value. While there are many different methods for doing a search, in this article I will only cover the basic method of using a For Next loop. In

No Thumbnail

Referencing Ranges In Excel Using VBA

In this article I will explain how to work with the Range and Cell objects. While the terms range and cells may be used interchangeably, they are two different objects, and have different functions and properties. There are two main notations for referencing ranges: Range(“A1:B1”) notation Range( Cells(1,