Iam sorry I seem to have done it wrong it does not seem recongnise the naming
of the range

"matt_the_brum" wrote:


Highlight your list, type a name for it in the white box on the top left
of the screen that usually shows the cell name.
Then do Data Validation-List and type in source =name of range


--
matt_the_brum
------------------------------------------------------------------------
matt_the_brum's Profile: http://www.excelforum.com/member.php...fo&userid=5751
View this thread: http://www.excelforum.com/showthread...hreadid=567879