vba arrayformula

  1. D

    VBA - entering a formula without calculating it

    Hi all, When I enter an array formula via vba, for example something like this,...: Range("C5").Select For Count = 1 To MyVariable - 1 With ActiveCell .FormulaArray = "=SUM(IF(((Płatności!C[-1])=R[" & -3 - Count & "]C[0])*((Płatności!C[1]) _...
  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. C

    Help needed understanding VBA in Excel

    Hi, I've had the unfortunate task of trying to understand a piece of VBA written by another user (clearly more proficient than me) and amend it. See below Sub Agency() Dim i As Long, tgt As Long Dim cols As Variant cols = Array(2, 15, 28, 41, 54, 67, 80, 93) For i = 3 To 502 tgt =...
  4. R

    Converting ArrayFormula to VBA

    Hi, I have this working arrayformula in excel (only one sheet in the .xls): {=SUM(IF((C5:C25<3);G5:G25;0))-SUM(IF((C5:C25<3)+IF(ISNUMBER(SEARCH("*flat*";I5:I25;1));1;0)=2;G5:G25;0))} What I want to do now is to execute this array formula using VBA and store the result in cell A1. I tried...

Watch MrExcel Video

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