locked
How to get previous formula when a cell formula changes? RRS feed

  • Question

  • I'm using worksheet_change to log (numeric) cell value changes.   However, is there a way to determine the previous formula for a cell when the formula changes?  

    ajw

    Tuesday, November 15, 2016 6:26 PM

All replies

  • Re: get previous formula

    To get the previous formula from a cell, you have to log/save that formula before it is changed.
    Whatever you are doing to log/save cell values would probably work for formulas...
      x = Worksheets("sludge").Range("B10").Formula
      MyArray(2, 10) = x

    '---
    Jim Cone
    Portland, Oregon USA
    https://goo.gl/IUQUN2 (Dropbox)
    (free & commercial excel add-ins & workbooks)

    Wednesday, November 16, 2016 2:03 AM