worksheet name vba

  1. szita2000

    VBA Pass string variable to refer to worksheet

    Hi All. I am trying to refer to a worksheet by a string which is value of a cell. This is my code for this part: month = Sheet15.Range("K1").Value 'This is the string with the name of the worksheet (User selectable) Set y = Worksheets("month")...
  2. N

    Cannot Change Sheet Name in VB Editor

    Hello, So, I've highlighted my worksheet "Sheet2 (Instructions)" in the VB editor I pressed F4 to bring up the properties toolbar and I was able to changed the VB name of my worksheet to "Instructions". Therefore, in the VB editor, the worksheet is now called "Instructions (Instructions)". I...
  3. N

    Excel Worksheet Tab Name Vs. VBA Worksheet Name

    Hello, I have changed the "Tab Name" of my worksheet to "Instructions" but in the VB editor the worksheet is referred to as "Sheet3 (Instructions)". I cannot find out how to change the name in the VB editor from "Sheet3" to "Instructions". I'm surprised how frustrated this has made me. Must I...
  4. Z

    add 'name worksheet after cell' macro when creating sheet

    Hi all, In Excel (2003) I have this situation: one Summary worksheet, then a range of sheets containing project information. From the Summary, with a button a macro can be launched to add a new project sheet. This works perfectly. But I would like to name the new sheet after a cell (say C3) on...
  5. R

    return ws name formula not working after moving ws to new wb

    I am using the following formula to display the first 7 characters of a worksheet name in a cell. =LEFT(MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256),7) It works perfectly. However, when I copy the worksheet, move it it a new workbook and save the workbook with a name that is...
  6. K

    Need a permanent way to refer to Excel 2007 worksheets to use for VBA code

    Hello, I am using VBA to program a UserForm for a proposal workbook. The workbook has multiple tabs with related product data on them and the users of this form will be renaming the tabs and changing the order of the tabs/worksheets frequently. I am wondering if the worksheets in Excel have...

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