2Q:Indirect worksheet selection in macro, Calc off for specific sh

  • Thread starter Thread starter seed
  • Start date Start date
S

seed

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
 
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.
 
Back
Top