Subroutine in multiple Workbooks

  • Thread starter Thread starter michael.blaustein
  • Start date Start date
M

michael.blaustein

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
 
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
 
Back
Top