How to loop through a list of data on a worksheet by using macros in Excel

Home > Uncategorized > How to loop through a list of data on a worksheet by using macros in Excel

February 24th, 2005 Leave a comment Go to comments

How to loop through a list of data on a worksheet by using macros in Excel: “How to loop through a list of data on a worksheet by using macros in Excel

Article ID:299036

Last Review:September 23, 2004

Revision:1.0

This article was previously published under Q299036

SUMMARY

When you write a Microsoft Visual Basic for Applications (VBA) macro, you may have to loop through a list of data on a worksheet. There are several methods for performing this task. The ‘More Information’ section of this article contains information about the methods that you can use to search the following types of lists: ?A list that contains a known, constant number of rows.

?A dynamic list, or a list with an unknown number of rows.

?A list that contains a specific record.”