NumRows = Range('A2', Range('A2').End(xldown)).Rows.Count This code moves down column A to the end of the list: Sub Test1() To Search a List with a Constant, Known Number of Rows The following code samples assume that the list has a header row that starts in cell A1 and data that starts in cell A2.

Microsoft support engineers can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. Microsoft provides programming examples for illustration only, without warranty either expressed or implied. A list that contains a specific record.A dynamic list, or a list with an unknown number of rows.A list that contains a known, constant number of rows.The 'More Information' section of this article contains information about the methods that you can use to search the following types of lists: There are several methods for performing this task. When you write a Microsoft Visual Basic for Applications (VBA) macro, you may have to loop through a list of data on a worksheet.

Visual basic for excel for loop