Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Saving data | Excel Discussion (Misc queries) | |||
Saving data | Excel Discussion (Misc queries) | |||
saving data? | Excel Discussion (Misc queries) | |||
Saving data | New Users to Excel | |||
Saving Data | Excel Discussion (Misc queries) |