Hello, this is my very first try at using a formula for help (so please be patient with me if I make a mistake:) I have a growing knowledge of Excel and a very adolescent grasp of VBA. Having said that, I have created a sort of a calculator on Excel to assist me and those in my office with estimating for our excavating company. I have about ten fields left "unlocked" on the sheet for users to enter values (both drop lists of words as well as numbers) that then provides enough info for the calculator to figure out the appropriate layouts and material measurements etc. I have created a "Clear Sheet" macro button that can be clicked to clear all those fields and start over. I have made a basic module that selects the cell by ranges and then "ClearContent"s. However using that approach dumps the formulas as well which has forced me to write long function commands to make sure none of the results are dependent on formulas in those accessible cells. Is there a command that would clear those cells without erasing the formulas contained? Or not? Thanks.
