list worksheet names

  1. J

    List Worksheets that have a specific value in a cell

    Hi folks .. I have a macro that lists (as hyperlinks) the Names of an array of Worksheets. Problem for me is this is not dynamic. The Worksheets relate to staff and when they leave I have to change the Array. In each Worksheet I have cell U1 that tells me if the Staff Member is Active or...
  2. S

    list worksheet names that begins with a given word by formula

    Hi, I have an excel file that contains several worksheets, some of those worksheets' name begins with "Sheet" e.g (Sheet home, Sheet play, Sheet market and so on) and some of those aren't. Now I'm trying to list all worksheets name that begin with word "Sheet" by formula. so far I have found a...

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