Hi

Change A1 to the address of your drop down cell.

Range("A1") = ""

Regards,
Per

"Project Pooped!" skrev i
meddelelsen ...
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