Quick Question: Multiple Open Workbooks

[cicconmr]

We often have several spread sheets open at work, so the macro's sometime get called by one sheet but impact the active workbook and cause errors.

Normally I would just add Workbook("Title"). before my ranges, however, the name of the file changes every day with out rhyme or reason. They are based on client orders so every new workbook has some new name.

Is there any way in the world to make my module, when called by an event, execute in the proper workbook????

 

[Damon Ostrander]

Hi cicconmr,

If you are asking how to always have the macro operate on the workbook that contains the code, simply use the ThisWorkbook object rather than the ActiveWorkbook object to qualify your ranges, worksheets, etc.

Damon