I have triied to use the following code to save entered data. Howeve
it also deletes all the formulas in cells not used yet. I'm triing t
save data as it is entered. Once the data is entered the formula i
not need for that cell. However, future data is depended on th
formula in other cells not used yet. ??????


Sheet2.Activate
Set rng = Range("A3:E366")
If rng 0 Then
rng.Formula = rng.Value
Else
rng.Formula = rng.Formula
End If


Thank you again

--
Message posted from http://www.ExcelForum.com