Clear contents

[leighmills33]

Hello everyone,
I have used this formula to clear the contents of a sheet, this work when the button is clicked, the only thing it doesnt do is return the drop down boxes back to what they were previously, does anyone know how i can do this.

Worksheets("Cut List").Range("a1:a500").ClearContents

Thanks
leigh

[ravishankar]

HI
exclude the cell which has drop down from the range you are clearing.
Range(A1:A9).clearcontents
Range(A11:A500).clearcontents
Ravi

[leighmills33]

thanks, but what does this do to the formula's that are in the cells

[ravishankar]

My formula just avoids cell A10 assuming that , that is where drop down is located.If you explain your problem more clearly we can help you with better solutions.
RAvi

[leighmills33]

Well firstly i pull information from an outside program, then when the information is in excel i have another sheet shortening the external information. on another sheet once again i have a table that will look at the information needed and then output in a cell for example
=IF(A4="0715"; "2";
But then user may need to enter 3 which would loose the code. so is there a way round this to refresh after the user has edited, this is because if they save the formula will be lost!

Leigh