Page 3 of 3 FirstFirst 123
Results 21 to 22 of 22

Thread: Replace array formula with VBA
Thanks Thanks: 0 Likes Likes: 0

  1. #21
    Board Regular
    Join Date
    Apr 2013
    Posts
    1,055
    Post Thanks / Like
    Mentioned
    8 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Replace array formula with VBA

    Quote Originally Posted by jasonb75 View Post
    I see where you're coming from with your 1bn figure now
    Thanks for your reply.

    Looking at the data I have, it seems (because I don't have live data) the answer to your 12 criteria is yes, which makes the problem more complicated.

    As I said, I've already written the code using loops and it works but is slow.

    Using vlookups and index / match is faster but owing to the 255 character limit:

    Code:
    http://dailydoseofexcel.com/archives/2005/01/10/entering-long-array-formulas-in-vba/
    
    


    I have to split things up.
    Last edited by RoryA; Sep 23rd, 2019 at 08:00 AM.

  2. #22
    Board Regular
    Join Date
    Dec 2008
    Posts
    6,629
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Replace array formula with VBA

    If all 12 are potentially set then it will most likely be slow however you do it.

    If the data is sorted on those columns in both sheets, then you might be able to speed things up a bit.

    If you post your current loop code then it would give us an idea of what you have tried rather than starting from scratch and coming up with the same thing.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •