Is there a way to determine which object is out of range other that just being informed by Error 9: Subscript out of range. I ask this as I may have collegues in other branches running a custom macro. Then if they run it with variables not in place and this particular error occurs, I would like to trap the error with a message saying, " The workbook could not be found!" etc, other that the err. description of "Subscript out of range". In cases it may be a workbook, and other cases it could be a worksheet etc...so I need to know if Subscript could be determined to a particular object ??