Recording new Macro won't reset drop downs

  • Thread starter Thread starter Project Pooped!
  • Start date Start date
P

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
 
Hi

Change A1 to the address of your drop down cell.

Range("A1") = ""

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