I have a excel workbook with 4 sheets and have always used the "find" option and selected workbook and when I typed in my find item in the "Find What" box and selected "Find All" it would provide me with all the items in my workbook and then I could use the "Find Next" to see them one at a time and it would do a continuous loop of those items. Currently, for example if the find all shows 4 items it stops at the last or 4th items and if you click on next it goes to a blank page.
