Select Case range("C7").value
Case "Apple"
Sheets(1).activate
Range("G1").select
Case "Pear"
Sheets(1).activate
Range("G2").select
......

Case Else
msg="Can't find fruit, can't select cell"
msgbox msg
end select

May work for you

Steve
"cole7011" wrote in message
...

any ideas on how i would do the following ??

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


--
cole7011
------------------------------------------------------------------------
cole7011's Profile:
http://www.excelforum.com/member.php...o&userid=15476
View this thread: http://www.excelforum.com/showthread...hreadid=270594