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...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    • Replies: 31
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    • Replies: 26
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    • Replies: 24
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    • Replies: 23
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    • Replies: 23
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    • Replies: 23
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top