+ Reply to Thread
Results 1 to 2 of 2

VBA that can retrieve a default formula back to the cell when one specific cell changed

  1. #1
    Forum Contributor
    Join Date
    07-16-2012
    Location
    Fort Worth, Texas
    MS-Off Ver
    Excel 2010
    Posts
    378

    VBA that can retrieve a default formula back to the cell when one specific cell changed

    Hello,

    I have a formula in cell AG12= IF($D12=FALSE,AVERAGE(S12,E12),CB12) and this formula was dragged across from cell AG12 to AS12.

    This spreadsheet is like a template and people may delete the formula and enter their own numbers if necessary. So I wanted to know if it is possible when cell B4 changed its value those range above can have their formulas back like it used to be before somebody deleted the formulas.

    I really appreciate any help. THanks

  2. #2
    Valued Forum Contributor natefarm's Avatar
    Join Date
    04-22-2010
    Location
    Wichita, Kansas
    MS-Off Ver
    2016
    Posts
    1,020

    Re: VBA that can retrieve a default formula back to the cell when one specific cell change

    I'm unclear if you want just AG12 restored, or all of AG12:AS12. The first line below does AG12. For all, follow up with the 2nd line.

    Please Login or Register  to view this content.

+ 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: 12
    Last Post: 10-02-2014, 12:31 AM
  2. [SOLVED] Formula to retrieve mutiple values less than value in specific cell, but in date order.
    By rocksan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-18-2012, 11:33 PM
  3. Excel 2007 : Default Cell Format Changed
    By dkrassin in forum Excel General
    Replies: 3
    Last Post: 04-14-2011, 03:26 PM
  4. Insert cell A value into default text cell D for each specific row
    By badasstoymaster in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-16-2010, 03:40 PM
  5. Default Cell Format Changed
    By besmith33 in forum Excel General
    Replies: 6
    Last Post: 04-21-2010, 09:12 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