+ Reply to Thread
Results 1 to 5 of 5

Macro to Copy Array Formula

  1. #1
    Spammer
    Join Date
    08-20-2012
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    221

    Macro to Copy Array Formula

    I have an array formula in Col M2

    I would like a macro to copy it down to the last row where there is data in Col A

    It would be appreciated if someone could kindly amend my formula


    Please Login or Register  to view this content.

  2. #2
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Macro to Copy Array Formula

    Have you tried putting your data in a table? This makes copying formulas obsolete.

  3. #3
    Forum Contributor tax112's Avatar
    Join Date
    02-28-2013
    Location
    Thailand
    MS-Off Ver
    Excel 2003 | 2010
    Posts
    365

    Re: Macro to Copy Array Formula

    Quote Originally Posted by flupsie View Post
    I have an array formula in Col M2

    I would like a macro to copy it down to the last row where there is data in Col A

    It would be appreciated if someone could kindly amend my formula


    Please Login or Register  to view this content.
    Try:
    Please Login or Register  to view this content.

  4. #4
    Spammer
    Join Date
    08-20-2012
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    221

    Re: Macro to Copy Array Formula

    Thanks for the help


    When running the macro below, it returns #N/A. If I manually dray the Array from M2 downwards, It works perfectly. Once the formula has been dragged down, it can then be copied and paste as values to save memory


    The formula is an array formula

    Please Login or Register  to view this content.

  5. #5
    Spammer
    Join Date
    08-20-2012
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    221

    Re: Macro to Copy Array Formula

    Thanks for the reply. My data is not in a table

+ 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. [SOLVED] Copy and pasting Array Formula via Macro
    By danfullwood in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-06-2013, 09:01 AM
  2. Copy and past Array formula via macro
    By danfullwood in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-05-2013, 09:54 AM
  3. Macro to copy array of cells
    By Boston in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-10-2010, 12:28 PM
  4. Array - Copy Formula, Paste as Array
    By lilanngel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-08-2010, 08:20 AM
  5. copy array formula
    By JR573PUTT in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-16-2006, 06:12 PM
  6. copy an array formula
    By JR573PUTT in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-16-2006, 05:15 PM
  7. Copy An Array Formula
    By JR573PUTT in forum Excel General
    Replies: 2
    Last Post: 02-16-2006, 05:00 PM
  8. Need help to Copy and Paste array using macro
    By wira in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-11-2005, 04:06 AM

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