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

"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

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




"Per Jessen" wrote:

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

.

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

"Project Pooped!" skrev i
meddelelsen ...
I'm not sure, but I think I am beginning to grasp. A1 in this case is
blank,
correct?




"Per Jessen" wrote:

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

.