Im writing a code for a workbook which will freqently be copied and renamed.

In part of the code for this workbook it goes outside the workbook and then
has to reselect it

Windows("????????").Activate

How can I get it to know the name of the workbook the code is in?

Thanks,

Ciara