Excel: Dynamic Named Range, problem with data validation

Hi Folks, I am a newbee so please excuse any slips in rules. I have used the offset function to name a range which works fine. I have tried to use this "valid" name in a data validation selection. After entering the named source box excel reports that "The source evaluates to an error .." although this is not the case as it evaluates as expected. =offset(D2,0,0,COUNTA(D:D)-COUNTBLANK(D1:INDIRECT("D"&COUNTA(D:D)))1) This a saved as the name listlabour , in the validation option I have used list and the source as =listlabour. Does anyone have any ideas ?

This question generated 27 answers. To proceed to the answers, click here.

This thread is current as of April 12, 2014.

For more resources for Microsoft Excel