Hi,
Take a look at the brilliant solutions provided by Debra
http://www.contextures.com/xlDataVal13.html
HTH
Cheers
Carim
--
Carim
------------------------------------------------------------------------
Carim's Profile:
http://www.excelforum.com/member.php...o&userid=33259
View this thread:
http://www.excelforum.com/showthread...hreadid=531154