+ Reply to Thread
Results 1 to 4 of 4

Copying Formulas When Automatically Inserting a Row

  1. 11-17-2011, 02:02 PM #1
    tsturtz
    tsturtz is offline
    Registered User
    Join Date
    11-16-2011
    Location
    NV
    MS-Off Ver
    Excel 2003
    Posts
    7

    Cool Copying Formulas When Automatically Inserting a Row

    I am having a problem copying formulas down a row when a new row is inserted automatically. I have attached the workbook in question.

    Any help.

    Thanks,
    Tony
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 11-17-2011, 02:13 PM #2
    jeffreybrown
    jeffreybrown is offline
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,318

    Re: Copying Formulas When Automatically Inserting a Row

    Take a look at this link and see if it can be of some help...

    http://dmcritchie.mvps.org/excel/insrtrow.htm#insrtrow
    HTH
    Regards, Jeff
    Reply With QuoteRegister To Reply
  3. 11-17-2011, 02:19 PM #3
    Steffen Thomsen
    Steffen Thomsen is offline
    Valued Forum Contributor Steffen Thomsen's Avatar
    Join Date
    10-15-2010
    Location
    Kolding, Denmark
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    953

    Re: Copying Formulas When Automatically Inserting a Row

    Hi,

    The error in your code is with the range copied.

    Try it now
    Attached Files Attached Files
    Please take time to read the forum rules
    Reply With QuoteRegister To Reply
  4. 11-17-2011, 04:25 PM #4
    tsturtz
    tsturtz is offline
    Registered User
    Join Date
    11-16-2011
    Location
    NV
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Copying Formulas When Automatically Inserting a Row

    Works great, thanks.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1