Cell w/ formulas & manual Entries

[MarkReddell]

I have a worksheet that has 2 Colums that have 500 rows with a formula & also a Drop-Down List box. I want to be able to use these cells mainly for the formula, however sometimes a use the list in the drop down menu. I want t be able to restore the formula(s) in the cells able using them through the list drop down menu. How would be able to do this in a macro instead of copying & pasteing each cell !!! I need to be able to run a macro upon deleting an entry in a cell & copying that formula back into the same cell !!! Thanx 4 help !!! Mark

 

[VoG]

Multiple posts of the same nature

http://www.mrexcel.com/forum/showthread.php?t=618958
http://www.mrexcel.com/forum/showthread.php?t=619022
http://www.mrexcel.com/forum/showthread.php?t=619073
http://www.mrexcel.com/forum/showthread.php?t=619077

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).