Need help: debug/fix VBA code to create new worksheets from template and names list

[Ruede]

As to the error, this line

ws.Name = rngLoop.Value

is giving the error because rngLoop.Value equals "". A sheet must have a name. This statement

Set rng = .Range("B2", "B" & .Cells(Rows.Count, "B").End(xlUp).Row)

is returning 19 cells (screenshot https://imgur.com/E9O0J4R) because of the If statement in the formula. You can add

If rngLoop.Value = "" Then Exit For

under the For each line to stop looping when you encounter this.

Jdealano - you are a genius my friend. Adding that line to my code makes it run perfectly!!
Thanks!!