Hmmm...,

Tigeravatar, your macro works, with some caveats. It's slow with a large range;my test range is 11K rows, and it took 59 seconds to do it all (this is after turning off Screenupdating). It did a great job skipping the blanks, and each name is unique, but I'd sure like to add some variety to the names. Name1, Name2, Name3 just isn't real exciting. But, it will definitely work in a pinch. Thanks for it.