Thanks to this forum, I now know how to check a range with multiple cells to determine if it is blank. My next challenge is to check all the ranges in all of the worksheets in my workbook to ensure they are all blank before starting my procedure. I want to do this in Visual Basic but have no idea how to begin. I have about 15 range names I need to check. Should I be "looping" through relative or absolute sheetnames or range names ? Or should I be using Nested If Statements, or some third alternative? Any sample code would be greatly appreciated (as always).

Sincerely,

Fred