Change cell value immediately after a save
--
HTH
Bob Phillips
"cam" wrote in message
...
I have this set on a worksheet that initiates a save when
either cell F1 or F2 is changed
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
On Error GoTo ws_exit
If Not Intersect(Target, Range("f1:f2")) Is Nothing
Then
ThisWorkbook.Save
End If
ws_exit:
Application.EnableEvents = True
End Sub
After this save I need the values in cells E2 and F2 to be
reset to 0 (the number zero) using code as code changes
for some reason do not initiate the save. I need to
insure the user changes the value in cell E2 and F2 so
that the sheet will save and a RECALL formula I have will
update the running total from input in those 2 cells
[=RECALL(E2)+E2 and =RECALL(F2)+F2] THANKS!!! in advance
for any HELP!
|