VBA Code to Clear Cell

[ERed1]

Hi all,

I am trying to write a VBA code that will search the column and clear are cell with a specific value. For example, it will search column B for a cell containing the number "1". If it finds a cell contain "1", then that cell gets its contents cleared. I don't want it deleted so other columns and cells don't shift.

Thanks in advance for the help.

 

[Fluff]

There is no way that I know of that code could produce that error.
Have you modified it, or added it to some existing code?

 

[FrancisM]

Hi Fluff. Now I feel like a complete idiot. I closed with out saving & reopened. Apparently something changed. I just love technology. than for responding so quickly.

 

[Fluff]

Not sure I understand what you are on about, this is not your thread. Or are you and ERed1 the same person?

 

[FrancisM]

My bad. you are correct, it is not my Thread, it won't happen again.

 

[ERed1]

Assuming you have formatted the cell as m/d/yyyy then your cells contain 0 not 1

so would I put a 0 instead of "1/0/1900?

 

[Fluff]

You already have a 0 in those cells.

 

[ERed1]

So, is there a way to get the 0 to be cleared before it gets formatted to "1/0/1900"?

 

[Fluff]

Just replace the 1 in the code from post#4 with a 0

 

[ERed1]

I got it to work now. Thank you again for the help Fluff!

 

[Fluff]

You're welcome & thanks for the feedback