Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Looping | Excel Discussion (Misc queries) | |||
Looping | Excel Discussion (Misc queries) | |||
Next For looping in a If | Excel Programming | |||
Not Looping Through | Excel Programming | |||
Looping | Excel Programming |