Okay, to get this working I've had to change the davv... reference t
the actual worksheet name instead, like: 'Validation Values'!C1. Stil
can't understand why I can't just reference a variable but I need t
get the working. I'm sure it's something quite basic and fundamental i
relation to the way you should use/declare variables so I would stil
appreciate any advice to prevent similar issues in the future?

Thanks,

Adria

--
Kobayash
-----------------------------------------------------------------------
Kobayashi's Profile: http://www.excelforum.com/member.php...info&userid=87
View this thread: http://www.excelforum.com/showthread.php?threadid=27358