Recording new Macro won't reset drop downs

[Project Pooped!]

The title pretty much says it all. I am creating a "Clear Sheet" macro.
When recording the macro I am clearing all data from necessary fields.
However, I have a drop down with 5 account code numbers and one blank spot.
When I am recording the macro I reset manually the drop down arrow to the
blank choice. When I complete recording and run the "Clear Sheet" macro it
clears everything out fine, but does not change the drop down to the blank
spot. Can anyone tell me what I am doing wrong, or perhaps a better way of
getting around this problem.

Thanks in Advance

 

[Per Jessen]

Hi

Change A1 to the address of your drop down cell.

Range("A1") = ""

Regards,
Per

 

[Project Pooped!]

I'm not sure, but I think I am beginning to grasp. A1 in this case is blank,
correct?

 

[Per Jessen]

Yes, A1 will be blank (none of the values in the validation list are
selected)