Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Row select mode to highlight active row of active cell | Excel Discussion (Misc queries) | |||
set the background color of the current cell(active cell) | New Users to Excel | |||
referring to formula in a non active cell from active cell | Excel Discussion (Misc queries) | |||
HOW TO COPY 480 ACTIVE E-MAIL ADDRESSES CLM "G" ON AN ACTIVE EXCE. | Excel Discussion (Misc queries) | |||
Select First Active Cell if the cell is in a pivot table | Excel Programming |