Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I move multiple tabs in multiple workbooks to a master? | Excel Worksheet Functions | |||
Call a subroutine using variable subroutine name | Excel Discussion (Misc queries) | |||
Updating Workbooks from multiple links Workbooks | Excel Worksheet Functions | |||
Combine multiple workbooks into 1 workbook w/ multiple worksheets | Excel Discussion (Misc queries) | |||
How to use this subroutine on multiple cells? | Excel Worksheet Functions |