when you type a data ( event a dot ) in a cell, the old data (incl. FORMULA) in the cell will be removed and replaced with the new data.
with macro you can "automatically" keep the old data (and stored in another place) and then enter the new value in the same cell cmiiw On Mon, May 23, 2011 at 5:21 AM, Bob <bobandrich...@comcast.net> wrote: > Is there a way to keep the formula in the cell when you enter your own > value? Thanks in advance > > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
