Creating new sheets with names from a range of cells with values eliminating the blanks.

[Colin Kuteesa]

I am trying to create new sheets (with names) from values in a range of cells say A1:AZ30 some of which at some point have blanks. The code below can create the new sheets with names (of values in cells) but when the program find a blank it out puts and error and stops. it also creates an unnamed sheet. How do i avoid that? i want it to be able to skip the blanks and continue with the rest of the cells with values.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Kindly help me improve this or give me a better option.

Also want to be able to automatically add a template/table to every newly created sheet.

Thank you.

Colin

[AlphaFrog]

Create a sheet called Template that has your table already on it. The code below copies that sheet.

Please Login or Register  to view this content.

[BMV]

Please Login or Register  to view this content.

From template )hidden sheet "templ" as example

Please Login or Register  to view this content.