Hello -

I would like to write a macro that will be housed in a separate worksheet that will run in different workbook. But, the workbook that I would like the macro to run will be named different each time it is run.

Example: Macro's are housed in workbook named "MASTER.xlsm" and the macro will need to run in workbooks with names such as flowers sheet 1, cars sheet 1, trucks sheet 1, etc.

How would I designate the active workbook and active worksheet?

Thanks a bunch!