I have two workbooks open, Workbook1 and Workbook2. In the VBA code of Workbook1, it is reading a set of rows. When it encounters a condition or value, I want to write something in Sheet1 of Workbook2, without having to activate the second Workbook and selecting the first sheet. I don't want to have to toggle back and forth between workbooks. Is there a way to write something in Workbook2 without selecting or activating?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
