+ Reply to Thread
Results 1 to 4 of 4

Auto filling with array formulas

  1. #1
    Registered User
    Join Date
    07-14-2014
    Location
    Ohio
    MS-Off Ver
    2013
    Posts
    15

    Auto filling with array formulas

    I need to know how to copy/pasta continuing down a column. For each time my macro adds in a new data row. My curgent macro copies five rows of data analysis formulas.
    In my case column "K" is an array formula and keeps on erroring out.
    Can someone show me a simple to do this.
    for kicks why is it that arrays are different that they can't just be copy and pasted easily in via?

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,004

    Re: Auto filling with array formulas

    Arrays need to be entered pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula.

    As to why this is not working for you...if it is not being entered using CSE, that is why

    What exactly is teh formula, and why do you need a macro to copy it down, instrad of just copying it down in the normal way (using copy/paste or dragging)?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    07-14-2014
    Location
    Ohio
    MS-Off Ver
    2013
    Posts
    15
    Quote Originally Posted by FDibbins View Post
    Arrays need to be entered pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula.

    As to why this is not working for you...if it is not being entered using CSE, that is why

    What exactly is teh formula, and why do you need a macro to copy it down, instrad of just copying it down in the normal way (using copy/paste or dragging)?
    Sorry about that.
    The reason why I can't simply drag manually is that this spreadsheet is populated by a userform. This sheet remains very hidden. So I need automation for this
    SAY THANKS
    I DO THE SAME.

  4. #4
    Forum Contributor
    Join Date
    08-14-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    782

    Re: Auto filling with array formulas

    Try this:

    Range("A1").FormulaArray = "=YOUR FORMULA HERE))"

    Regards,
    tt3

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Auto Filling Parts of Formulas
    By ande2428 in forum Excel General
    Replies: 2
    Last Post: 10-13-2010, 10:56 AM
  2. Filling down array formulas
    By tomlancaster in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-01-2009, 07:22 AM
  3. Paste formulas without auto filling
    By naquer in forum Excel General
    Replies: 7
    Last Post: 09-28-2009, 04:13 AM
  4. Auto filling formulas
    By Jessejh in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-02-2009, 10:07 AM
  5. Auto filling formulas?
    By foreverloved in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-29-2006, 02:34 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1