select sheets

  1. J

    Add sheets to array and select

    Hello All, I got 5 sheets with different tabcolors. The tab of a sheet becomes red when a certain value on the sheet isn't met. When it is, it becomes green. The only sheets I want to select as an array are the green sheets. How can I do this? For example: Sheet 1 tab color = Green Sheet 2 tab...
  2. T

    Selecting sheets (tabs) based on name and a cell value

    This is a bit beyond my reach. I'm needing to write some vba that I can assign to a macro button which will select the names of those sheets determined by a marker "X" running from a front page summary sheet which is basically as follows: Tab Name (Col A7:Z Last row) is where the sheet names...
  3. C

    Recalling a multiple sheet selection in VBA

    Hi, I have a macro that will select multiple sheets at one point. I'm trying to think of a way to recall that selection later on, possibly by naming it when it's first selected. I thought something like this would work, but no dice: SheetstoPrint = Sheets(ActiveWindow.SelectedSheets) ...
  4. cgeorge4

    MacroProblem-How to All Sheets Except One Specific Sheet

    Hello, I hope some Darling can assist me. I have a macro that selects all sheets - no matter how they are named - or how many sheets there are (normally 5 to 10 new sheets). The problem is that there are sheet names in my macro and I might have one new sheet or two with different names from...
  5. J

    Userform Combo Box switches sheet but doesn't enter data into active sheet

    I have put together a Userform for entering data into a series of identical spreadsheets in the same workbook. The form contains a combo box that switches the active worksheet by selecting the sheet's number. However, once the new sheet is selected, the Userform continues to edit the cells in...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top