ExcelBanter - 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!