name worksheet

  1. L

    Copy tabs in new excel VBA

    Hi, I have this code where it creates a new worksheet and copy those 2 tabs, but I would like it to also name the worksheet, is that possible? Sub CopiaFactura() ThisWorkbook.Sheets(Array("U-Main", "U-Detail")).Copy End Sub Thanks a lot!
  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. S

    Macro to name sheets sudden;y stopped working

    I have a workbook to record orders and when I add the current order to the history it creates a new page and then renames it to the value of B3. It worked fine for a while, then suddenly this yaer everytime I try to add the order to history I get I have checked and there are no sheets named...
  5. B

    Naming worksheets from a series of cells on a table

    Hello, Please help me.... Having a table in a worksheet, I need to open additional worksheets which would be named by text strings in the table. How can I do that? Any help?
  6. K

    Renaming Worksheet Tabs Macro

    I would like to create a macro that would bring up an input box or preferably a list box that will allow me to input information for a sheet/tab name where where "TBL NPL NGRPL" appears in the code at the end of this message. The macro needs to be available to any new file created...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...