exclude certain sheets

  1. J

    Sum 2 columns on every Ws (except 3)and if they are equal to each other change their fill color

    I need to get my code to Sum 2 columns on every Ws and if they are equal to each other change their fill color. i need to do this for 40 sheets but i have 3 sheets this doesnt need to happen for. My current code only does the Sum for the active sheet i am on and i havent been able to get the...
    • JakariKryze
    • Thread
    • change fill color exclude certain sheets loop through worksheets sum columns
    • Replies: 3
    • Forum: Excel Questions
  2. M

    Table of Contents (Mulitple Columns)(Excludes several sheets)

    Hey folks, I have found several examples of how to make a TABLE of Contents (single column), but I have only found one which displays multiple columns. The code below works well, however, when I attempt to "exclude" additional sheets, I get an array error. I am not good at arrays...
    • MarqyMarq
    • Thread
    • exclude certain sheets multiple columns table_of_contents
    • Replies: 3
    • Forum: Excel Questions

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