There is probably a real simple code but I looked around and could not find it. At any given point I will have two workbooks open, one will remain and the other will be closed and another one open so the workbook name will change. How do I get VBA to select the inactive workbook since the name will change? I hope that makes sense.