vba array function

  1. V

    How to VBA for Find and Replace (array) - trying to maximize efficiency

    I need help. I am new to this forum, but I am trying to use VBA to find and replace using an array (since I found that it could shorten the run (process) time considerably). The issue I am having is that my current code takes about 20 minutes to complete and I have to do this twice. It loops...
  2. F

    VBA listbox value to cell

    I initialize a userform and a listbox with different types of options like this: --- Private Sub UserForm_Initialize() ArrayPrimarEmb = Array("-- Ange Alternativ --", "Kit", "Rund Tub", "Platt Tub", "Oval Tub", "Glasflaska", "Fyrkantig Flaska", "Oval Flaska", "Rund Flaska", "Burk", "Tunna med...
  3. 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
  4. S

    Function that returns an array in VBA

    Hello all, I have a function that prints all my data in the sheet to a text file in an array format like following [ ['ID', 'Label', 'Longitude', 'Latitude', 'Country', 'Region', 'Ttl_wt_Flw_thru', 'Sum-of-BOL-Wt', 'Count of WDR_Ref', 'Ratio'], ['AEAUH', 'Abu Dhabi, United Arab Emirates'...

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