| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
