Clear Cell in VBA not FormulaR1C1 = ""

Hi everyone,


I am trying to create a macro that will clear the contents of a cell with a conditional drop down value. I have a main drop down, and a conditional. If the main one is cleared or changed, I would like the cascading drop down to also clear.

I need the formatting to remain the same, though, so I cannot simply delete the cell.

My issue arises when I use the code:

Please Login or Register  to view this content.

For some reason, this change takes 5 - 8 seconds to implement, and it completely locks up excel in the mean time. Without this single line of code, all my other macros run instantly. Is there some sort of strange effect with clearing a drop down? And if so, does anyone know of another line of code which would work better to clear the contents of the cell?

Thanks for the help.

Thanks for the help. Maybe it is places in the wrong place...

How far into the code should this be placed? Most of my other pieces don't work when I put this in there, strangely enough including the clearing of that cell...

It is based on a select case code, should this be within the case, or just before the case statement, or right after the declarations?

That is where I figured it should go. It causes much of my code to not run.