+ Reply to Thread
Results 1 to 4 of 4

VBA - How to make formulas dynamic when inserting new rows?

  1. #1
    Registered User
    Join Date
    04-10-2014
    Location
    Brussels
    MS-Off Ver
    Excel 2013
    Posts
    8

    VBA - How to make formulas dynamic when inserting new rows?

    Hello everyone,

    I have a macro that insert new blank rows, then copy and paste some rows, based on a input userbox. Those last rows contain formulas but, once pasting them, they become incorrect (problem of references). I'd like to make the formulas dynamic in the macro code (via R1C1) or via Index function so that inserting news rows, results don't change. As you can see on the picture, some cells are refering to another sheet, some are in absolute / relative references, but at the end, only rows #19 and #20 contain formulas.

    How can I adapt the code below?

    Please Login or Register  to view this content.
    Note that I've already posted this thread on Mr Excel and Ozgrid, but it seems I can't upload the links..

    Thanks a lot !
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    18,705

    Re: VBA - How to make formulas dynamic when inserting new rows?

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important. Instead of copying and pasting the links, type them out.

    (Note: this requirement is not optional. No help to be offered until the link is provided.)

  3. #3
    Registered User
    Join Date
    04-10-2014
    Location
    Brussels
    MS-Off Ver
    Excel 2013
    Posts
    8

    Re: VBA - How to make formulas dynamic when inserting new rows?

    Hi, thanks, but like I said above, I can't upload the links where I've also posted this thread (I don't have enough posts yet or whatever).

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    18,705

    Re: VBA - How to make formulas dynamic when inserting new rows?

    As I said in my post. Type the links manually. Do not try to copy and paste them.

+ 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. Replies: 2
    Last Post: 03-03-2018, 02:34 PM
  2. Change Array formulas to make them Dynamic
    By julhs in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-09-2017, 09:01 AM
  3. [SOLVED] Inserting a row that will make formulas follow
    By OUO in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-22-2015, 10:32 AM
  4. [SOLVED] VBA to enter various formulas every 10 rows and show dynamic formulas not values
    By faby2203 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-04-2013, 07:05 AM
  5. Inserting New Rows with Formulas
    By TimCar in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-25-2012, 03:29 AM
  6. Make Table Names in Formulas Dynamic
    By bbailey19087 in forum Excel General
    Replies: 1
    Last Post: 09-21-2011, 05:57 PM
  7. Inserting Rows with Formulas
    By Christian411 in forum Excel General
    Replies: 2
    Last Post: 01-16-2008, 06:17 AM

Tags for this Thread

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