Subroutine in multiple Workbooks
I have a simple subroutine that does a Find Replace on the first column
of a worksheet. I get workbooks e-mailed to me that I want to run this subroutine on. Is there anyway to do this other than copy and paste the code onto each new workbook? Thank you, Michael |
Subroutine in multiple Workbooks
Hi Michael
Copy the code in your personal.xls and use activesheet in your code You can run the macro then in any worksheet that is active If you need more help post back -- Regards Ron de Bruin http://www.rondebruin.nl wrote in message ups.com... I have a simple subroutine that does a Find Replace on the first column of a worksheet. I get workbooks e-mailed to me that I want to run this subroutine on. Is there anyway to do this other than copy and paste the code onto each new workbook? Thank you, Michael |
All times are GMT +1. The time now is 03:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com