Thanks for that but i didnt mean that. What i mean is when i copy the
content of the cell to the next cell down i want the value in the
validate bit to change like this:
=H47
=H48
but instead its doing this
=H47
=H49


--
loiboi
------------------------------------------------------------------------
loiboi's Profile: http://www.excelforum.com/member.php...o&userid=25621
View this thread: http://www.excelforum.com/showthread...hreadid=390361