vba courses london - Macros - Enabling them to work across multiple workbooks

Hi Alex

I believe the peice of VBA code that you are looking for, to include in your macro is:

Workbooks("YourWorkbook").activate

where you place the name of your workbook in the above statement where is says yourworkbook.

If this does not solve your problem get back to me

Hope this helps

David