any ideas on how i would do the following ??

If cell C7 equals Apple then active select a cell g1 in worksheet
however if it pear then do the same but this time select G2 and so wit
different condtions and different locations to were it needs to selec

--
cole701
-----------------------------------------------------------------------
cole7011's Profile: http://www.excelforum.com/member.php...fo&userid=1547
View this thread: http://www.excelforum.com/showthread.php?threadid=27059