$$A$($n$)\_\_\_\_\_\_\_\_$ macro reference affects the same cell address every time the macro is run. Named ranges that are to be used as lists of values for data validationA. must be in a different workbook than where the validation is appliedB. must be in the same worksheet where the validation is appliedC. must be in the same workbook where the validation is appliedD. must be in a different worksheet than where the validation is applied