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: “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.”

Related Posts

My experiments with sparklines

Auto Filter Cursor Movement

Things they didn’t teach in school

Create Sheets based on a Column

Student’s t-test for equal means

About the Author

A co-author of Data Science for Fundraising, an award winning keynote speaker, Ashutosh R. Nandeshwar is one of the few analytics professionals in the higher education industry who has developed analytical solutions for all stages of the student life cycle (from recruitment to giving). He enjoys speaking about the power of data, as well as ranting about data professionals who chase after “interesting” things. He earned his PhD/MS from West Virginia University and his BEng from Nagpur University, all in industrial engineering. Currently, he is leading the data science, reporting, and prospect development efforts at the University of Southern California.

>