ClearContent for drop-down fields

[PhilMc]

Hi, I havecreated a template for my staff to use. I've written code that generates aunique sequence number and saves the file but I am having trouble when it comesto removing any information that may have been pre-existing on the form. I amcurrently using the ClearContents command but I've found this also removes anyexisting drop-down fields? Is there another command I can use to either clearthe drop-down fields or return them to default/null value?
Thanks

 

[Norie]

How did you create the dropdown fields?

If it was with Data>Validation then using ClearContents shouldn't remove the dropdowns, it should only remove the value in the cell(s).