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")...
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...
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...
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...
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...
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 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.