The macro is using range names, the error message you state happens if there is an issue with any of those range names.