Quote Originally Posted by HaHoBe View Post
Hi, John,

using SaveAs and assuming that a user who indicates 2007/2010 as used Excelversion uses *.xls as Standard File is a bit off the target for me and maybe one reason for an error (maybe refer to Ron de Bruin on SaveAs from 2007 on).

Besides: building an array with unique names and applying the Autofilter while looping through the array could prove to be a far more elegant way.

Ciao,
Holger.
Good points Holger. I definitely will refer Ron de Bruins SaveAs.