Hi Robert,

Am Wed, 25 Nov 2015 18:51:23 -0700 schrieb Robert Crandal:

The user will enter a number that is specific to our data. The number
chosen will be any integer greater than 1. Also, the chosen number
can never be predicted; that's why I say it's a random number.

So, suppose a user chooses number 32. That means:
version1.xlsm will have 32 in cell A1, and...
version2.xlsm will have 33 in cell A1, and...
version3.xlsm will have 34 in cell A1, and...
etcetera, etcetera...

do you want to copy "main" because of the macros? What macros do you
have in "main"? Macros in modules or event macros?
Do you overwrite the existing workbooks if you name the new ones always
"version" & i?


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional