i'm afraid that didn't work. what i have done, is remove the formula from the sheet and i have it being entered with vba like this
Application.EnableEvents = False
Range("E120").Formula = "=IF(T104=""Used"",R104,IF(T104=0,0))"
Application.EnableEvents = True
now, if i hit delete on E120, A5 updates as it should. i have not been able to make this automated, however. i have tried
range("E120").select
selection.clearcontents
, but that doesn't work to update A5. is there a way to force a refresh after the formula is placed? i've even tried coding in a delete of the cell.
Bookmarks