Help with looping
 

Hello everyone,

I need some help w/ looping. I have a macro that is creating a new
workbook with worksheets for reports. It is automatically going to
create these sheets, but the variables are not always the same. I am
thinking of doing a loop but not sure how to write it. It needs to
loop based on a group of data that is going to change.

in combobox1 I have a list of names. I have the macro to create the
tab and to rename the tab. However, I need it to run the macro for
each selection in combobox1. The list changes based on the inputs from
the user. The macro, "Generate_Report" is what generates the tabs. How
would I write the Loop command to run Generate_Report using A:A as the
source data?

combobox1 has 50 available options (but this can change from day to
day), I need to Loop Generate_Report for each of the listed options in
the combobox.


--
dok112
------------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...o&userid=10581
View this thread: http://www.excelforum.com/showthread...hreadid=480865