sheets select

  1. H

    Code for manually select a tab

    hi all, I've created a VBA code that imports part of a workbook into a reporting spreadsheet. this works really well until users decide to change the sheets. The code is quite extensive so I will just post the relevant part of it. 'Open source file Dim fNameAndPath As Variant fNameAndPath =...
    • husoi
    • Thread
    • code file sheets select tab tabs selection
    • Replies: 12
    • Forum: Excel Questions
  2. K

    VBA to select all sheets after number 5 to end of workbook then Paste format

    I currently use an array of named sheets but sometimes other names may be present and then on others occasions not all these will be there. how do I change Sheets(Array("WORK", "WOLV", "WENT", "WEB", "STKE", "SHEF", "SCUN", "SAX", "SAW", _ "ROTC", "LICH", "LEED", "IPS", "HULL", "HIT"...
    • Kimpnc
    • Thread
    • named sheets sheets select vba array autofilter vba array function
    • Replies: 1
    • 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