HI!

You've helped out by showing me how to use array to copy 2 sheets to a new
file and name that new file... the next problem I need help with is I need
to copy the formats as well... and not the links to the new file...
(Actually all I really need to do is format Column "A" to 0000)

I remember seeing info on something like this but I can't seem to find it...
I can do the copy formats on a normal copy/paste but it seems to lose
something in the translation when I try to use the same approach with this
array part of my macro...

Or is there a way to format column "A" before naming and saving the new
workbook?

sorry to be such a pain... but 35 restaurants will be pretty happy if I ever
get this project completed...

Greg