No, all you need to do is to set a workbook object for each workbook as you
add them

Set wb1 = Workbooks.Add
Set wb2 = Workbooks.Add
With wb1
.etc
End With

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Andibevan" wrote in message
...
If I create 2 workbooks using workbooks.add - how do I refer to the first
inserted workbook as the second is active?

Do I need to save the workbooks in order to be able to reference /
activate
them?

Any pointers would be appreciated.

Ta

Andi