Hi,
Unsure of the best way to achieve this
Example: this workbook.Sheets("Sheet1").Range("A1") = "OrangeBlue"
I have a folder with 12 files and I want to fetch the row of each workbook where "OrangeBlue" is found.
I know how to loop through and open/close each file, just unsure of the VBA...