+ Reply to Thread
Results 1 to 3 of 3

Change Array formulas to make them Dynamic

  1. #1
    Forum Contributor
    Join Date
    01-18-2012
    Location
    nr Salisbury, UK
    MS-Off Ver
    Excel 2010
    Posts
    126

    Change Array formulas to make them Dynamic

    I have been helped out greatly with the Vba code for my User form, but I now need to alter these Array formulas that are in
    the Summary section of the Worksheet to make them dynamic.

    Previously they were static, placed at the bottom of the Input section and so worked fine. But a Userform will now be adding
    the data and extending the Input section as it goes, so consequently throwing them all out, by being dynamic they will deal with
    being constantly shifted downwards.

    Below are the codes in question but have attached is complete demo WorkBook



    Please Login or Register  to view this content.

    Hoping someone can help me out.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    01-18-2012
    Location
    nr Salisbury, UK
    MS-Off Ver
    Excel 2010
    Posts
    126

    Re: Change Array formulas to make them Dynamic

    Is this even possible or is it a case of having to completely rethink things?

  3. #3
    Forum Contributor
    Join Date
    01-18-2012
    Location
    nr Salisbury, UK
    MS-Off Ver
    Excel 2010
    Posts
    126

    Re: Change Array formulas to make them Dynamic

    Can anyone explain as to why the array formulas in my post#1 behave dynamically and adjust accordingly when I
    manually insert a row to the range above them.

    But when the UserForm inserts a row to add new data the arrays don’t behave dynamically.

+ 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] how can i make this array change the cell in a column based on a text array
    By dmcgov in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-25-2016, 09:44 AM
  2. Dynamic ranges in array formulas.
    By smatchymo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-03-2016, 07:59 AM
  3. [SOLVED] Dynamic Search function using array formulas
    By adelcap in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-20-2012, 05:46 AM
  4. Change all regular formulas into array formulas
    By sans in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 06-18-2012, 11:28 AM
  5. Replies: 2
    Last Post: 11-05-2011, 03:26 PM
  6. Make Table Names in Formulas Dynamic
    By bbailey19087 in forum Excel General
    Replies: 1
    Last Post: 09-21-2011, 05:57 PM
  7. Can you create dynamic named ranges containing array formulas?
    By Marie J-son in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-28-2006, 09:10 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