vba array fromula

  1. J

    Set variable to value returned by complex array formula

    I'm attempting to set a variable in VBA to the value returned when executing this array formula during a loop: {=INDEX(Tbl_Findings[RvwrLen],MATCH(1,(Tbl_Findings[Intake Number]=TEXT($B$2,"0"))*(Tbl_Findings[Question#]=A6),0))+2} I've attempted to use the Evaluate method but can't seem to get...
  2. F

    Loop + Vlookup

    Hi, in one sheet I have data like: A1: Audi B1:A3 A2: BMW B2:Z300 A3: Ford B3:Fiesta A4: Audi B4: A4 A5: Ford B5: Mondeo in second sheet I have unique value: A1: Audi A2: BMW A3: Ford Now I want to insert into second sheet in B1, B2... all value from sheet1 for Audi, Ford etc...: B1: A3, A4...
  3. E

    Sheets(Array(...)).Select Question

    Hi, I am trying to use the following code, but I keep getting the "Subscript Out of Range" error. I'm sure it has to do with the my variable: The code basically looks in each worksheet to see if there is data in it and if there is, I want to print that to PDF. Dim ArrSheets As String...
  4. L

    VBA code to store an array formula

    Can someone help me determine the right code to store an array formula into a cell? For example, I can use the below to store a non-array formula but how do I modify it to store an array formula? (i.e. with the curly braces on the outside) Generally, we would have to hold down...

This Week's Hot Topics

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
Top