looking for help with For/Each VBA code

[fredderf81]

hi all, im sure this is simple but for SOME reason i have been having trouble grasping the concept of how to properly loop something or execute a for/each statement so if anyone knows a nice website with a tutorial on this that is easy to understand i would love that as well. anyways, what i am trying to do is simple i think. i have the code for an input box to come up for the user to type in a number. the number is assigned an integer variable, sheet_count, this is the number of new sheets i will create in the workbook. then i need code for what i think is an array??

something like: for each worksheet in sheet_count, then other code in here

i just can't grasp it, sorry if this seems really stupid!! =)

[Norie]

You wouldn't use For Each for that, you would use a standard For like this.

For example.

Please Login or Register  to view this content.

[fredderf81]

AHH!! thank you so much Norie, i really have to nail this stuff down into my brain.

[RudiS]

You actually don't need a loop for that at all. You can just use the Count argument of Sheets.Add

Please Login or Register  to view this content.

[fredderf81]

oh excellent!! thanks rudis, as it works out, this works perfect for the one thing, and Norie's code solves another issue i would have had a question on anyways =)

many thanks

[RudiS]

LOL.... The value of 1 question ... You get double the return.
That's a great investment!