LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Saving Data

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Saving data Sidney Excel Discussion (Misc queries) 0 February 25th 10 02:10 PM
Saving data Formula help Excel Discussion (Misc queries) 2 July 26th 09 04:40 AM
saving data? Rhea Excel Discussion (Misc queries) 3 July 22nd 09 02:36 PM
Saving data PennsyNut New Users to Excel 3 November 5th 07 11:41 PM
Saving Data puppynanee Excel Discussion (Misc queries) 0 March 29th 06 09:32 PM


All times are GMT +1. The time now is 09:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"