Just guessing...

"basiclly based on Debra Dalgleish code"... means from http://www.contextures.com/xlDataVal11.html

Maybe the question at http://stackoverflow.com/questions/3...n-the-workbook is similar to what you're asking with regards to every sheet.