How do I refer to a worksheet with a variable?

[Tardisgx]

Hi

Right now I open a new worksheet in my code and go back and forth by doing thisworkbook & previouswindow.

This goes wrong if I have a third workbook open and it just managed to delete a bunch of formulas the original document.

How do I open a new workbook and immediately say this workbook shall be known as "Derrick". Then switch to and from this workbook & Derrick?

I could immediately save the document in a location and refer to it physically but that seems like a lot to achieve a solid reference.

 

[Norie]

How are you opening/creating the new worksheet (or is it a workbook)?

If it is a workbook you can open/create it and set a reference to it like this.

Dim Derrick As Workbook

    Set Derrick = Workbooks.Open("C:\TheNewWorkbook.xlsx") ' Workbooks.Add

You can then use the reference you've created, i.e. Derrick, to refer to the workbook that's been opened/created.

 

[Tardisgx]

Wow what a dumb mistake; yes i meant a new workbook; thank you