Automating Find & Replace

Hi, the reason that you are having issue with that line of code is that the Template workbook is opened by the masterworkbook. If it starts closed than it will run.

Thanks,

Gregg

Originally Posted by greggpetersen75

Hi, the reason that you are having issue with that line of code is that the Template workbook is opened by the masterworkbook. If it starts closed than it will run.

Thanks,

Gregg

Hey Greg!

I have both files in the same folder. When I open the MasterSheet and click on "replace code" I get a DEBUG error. It highlights that syntax I previously mentioned. The Project_Master_Template file is not open at this time.