Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
2Q:Indirect worksheet selection in macro, Calc off for specific sh
I'm having trouble finding the code to use within a macro to select a
worksheet based on the value entered into a certain cell. What I have is a worksheet for entering data and a macro that organizes and copies the data to other sheets, one being a catch-all for all data and another being a sheet corresponding to a specific value entered in B2. Options for data in B2 are validated from a list in another sheet, and a worksheet of exactly the same name already exists for each option available in B2. I just need the macro to choose the sheet corresponding to B2. 2nd question: Is it possible to change a specific sheet to manual calculation, or must the calculation method selected always affect the workbook as a whole? Thanks all. Ryan |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
2Q:Indirect worksheet selection in macro, Calc off for specific sh
In case anyone comes up with this message in a future search - I know I find
90% of the answers by searching rather than bugging others for help - Worksheets(ActiveSheet.Range("B2").Value).Activate Where B2 is the cell containing the desired sheet name can be used. Depending on your macro you may want to put a Sheets.("whatever").Select command in prior to make sure you're taking the correct cell from the correct sheet. Figured it out on my own, finally. "seed" wrote: I'm having trouble finding the code to use within a macro to select a worksheet based on the value entered into a certain cell. What I have is a worksheet for entering data and a macro that organizes and copies the data to other sheets, one being a catch-all for all data and another being a sheet corresponding to a specific value entered in B2. Options for data in B2 are validated from a list in another sheet, and a worksheet of exactly the same name already exists for each option available in B2. I just need the macro to choose the sheet corresponding to B2. 2nd question: Is it possible to change a specific sheet to manual calculation, or must the calculation method selected always affect the workbook as a whole? Thanks all. Ryan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
make a macro 'worksheet specific' | Excel Discussion (Misc queries) | |||
Linking a selection in a drop down list to a calc in another cell | Excel Worksheet Functions | |||
Worksheet, selection macro | Excel Worksheet Functions | |||
Help with a macro to open to a specific worksheet | Excel Worksheet Functions | |||
Using Indirect & Creating a worksheet Macro | Excel Worksheet Functions |