| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select sheet based on cell value
Could someone help me with some code? I have a workbook with twelve
worksheets named A, B,... I, J, Formula and Menu. On the Formula sheet, I have the following range of cells: A B C 1 10 A 30 2 20 B 3 30 C .... 9 90 I 10 100 J Based on the value of cell formula!C1 (which is 30) I would like to run a macro from the Menu sheet that will look up 30 in the range Formula!A1:B10 and return the value "C" to the macro that will select the worksheet named "C". Or, if there is a better way please let me know. TIA, Dan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| graph based on the city i select in a particular cell | Charts and Charting in Excel | |||
| Using VBA select sll sheets based on Criteria on each sheet. | Excel Discussion (Misc queries) | |||
| Select a cell based on an other cell's value | Excel Worksheet Functions | |||
| how can I select a range of cells based on a value of a cell? | Excel Discussion (Misc queries) | |||
| Select Columns based on cell value | Excel Programming | |||
Threaded Mode
