Increasing efficiency of my macro to copy sheets based on cell range

[benoj2005]

Can this macro be improved in two ways? Copying Sheets VBA.xlsm

1) So that if the cell in range A2:A11 is empty, do not create a sheet for that cell.
2) Some way of writing the code once and looping it so that I do not need to add in the same code 10 times for all cells in A2:A11 (Note i've only written it twice for this example).

Cheers guys

[buran]

Something like this?

Please Login or Register  to view this content.

[benoj2005]

Top man, thankyou.

One thing that would be even more helpful would be if you or anyone fancies adding in some 'annotations as to what each bit does

[buran]

It's really simple and self-explanatory macro and as you did some of it yourself I decided you don't need comments. here they are:

Please Login or Register  to view this content.

[benoj2005]

Very much appreciated