IF then Active Cell
 

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

IF then Active Cell
 

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