It will work because Workbooks is a collection of open workbooks, so it should just loop through one workbook if it's the only one open.
I changed the code above to reference the workbook the code is written in. That way, if you have other workbooks open, the code will work if the code is stored in the workbook you want to search. I also changed the datatype of "Variant1" and "Variant2" to a Double, which allows you to use just about any number you want. I would change the Variant1 & Variant2 names throughout the code to something more meaningful to you.
Bookmarks