change name worksheet

  1. V

    Change part of a file name using VBA

    Hi I have multiple folders with files created by an employee Scott, he has subsequently left the firm and all the files he created have his name in them, so for example files are called FFC Notes - Germany - Scott.xlsx Each one is a country but I have hundreds of files he worked on could someone...
  2. S

    Change Sheet Name

    Trying to figure out why this isn't working. When I change B2 to any number, it works fine and the sheet name is change to the corresponding number. But if I clear out the contents to B2 to blank, the sheet name stays the same as the previous number that was in B2. I would like it to change to...
    • spydey
    • Thread
    • change change name worksheet macro sheet name vba
    • Replies: 6
    • Forum: Excel Questions
  3. O

    Tabs Renamed as Cells Have the Same Name

    Hi. I have this macro that names worksheets after each of the contents of a list. The list drives output on a master worksheet related to the particular items from the list selected. The macro selects each item and copies the contents of each filtered result into its own worksheet and renames...
    • OldSoldier
    • Thread
    • alternative ws name change name worksheet worksheet name length worksheets worksheets named range
    • 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