Excel Name Definition using "indirect" formula within its Range target area

JKPieterse 

Dear Mr/Ms. Pieterse

Thanks, as told in my first posting, there us no error message & the same formula works

with Excel "Data Validation" Function as shown within the file linked here:

https://drive.google.com/file/d/1l7WaxCdNSw6cTtqWqeJEMya8pl3VRxrl/view?usp=sharing

Re: Excel Name Definition using "indirect" formula within its Range target area

I don't think the INDIRECT argument currently evaluates to a valid cell reference. Try this:
- Copy the current formula from the name and paste it into any cell.
- Press F2 on that cell, highlight everything between the brackets () and press the F9 key once. Copy the resulting string
- press escape
- select another cell and press the = sign and paste. Now try to enter. If the address was valid you should not receive an error.