Thanks ByteMarks. I can see that that would work, but is there a better way? Maybe some setting to direct excel to only look in the active workbook?