Why is my cell format changing after code execution?

I have an application that I am completing; however each time i think i am done my testing reveals something else. My issue here is whenever I get a runtime error my cell format changes, it even change the cell format if I delete multiple cells at once. It my first VBA program so i guess its not the best written program, but so far it does what i want. I just have this issue annoying me at this time.

Can anyone please look at the code and share a view or two? Thanks.

Please Login or Register  to view this content.

I can't see anything in that code that would change the format.

How exactly is it changing?

What is the code meant to do?

thank you both so much for looking at my code; I will try what shg says and report my result tomorrow.

because each area has adifferent validation, one exclues the C while the other includes the C. I am not as good as you guys are so I know the prgram may not have been written with much effeciency, but i am learning from you guys as i go along.

Ok shg, your suggestion worked, thank you so much.

Originally Posted by shg

Clear clears both the cell content and formatting -- use ClearContents. Also, you should test if more than one cell is affected. Untested:

Please Login or Register  to view this content.