vba array autofilter

  1. M

    Capturing and calling items in a dynamic VBA array

    I have an exported file, basically an Excel text spreadsheet with column headers and around 2000 lines. It can change, so I don't have a fixed array size. I have stumbled through things where I believe I can build the array, but get lost on essentially how to call out and display specific parts...
    • moltke
    • Thread
    • arrays and loop beginner help vba vba array autofilter
    • Replies: 1
    • 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
  3. C

    I cannot understand why this autofilter by array does not work

    I have a sub that will filter on criteria and then delete those rows, it's a sub so I can pass different filter criteria to it each time. I've decided to trim it down by passing an array instead of doing mnultiple separate filters on each row... but it fails. I'm using excel 2007. I've...

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