how can i place blank on entire column value contains "00-01-1900" through VBA

[m_vishal_c]

HI. I want to place blank (" ") on entire column . there are so many "00-01-1900" values . so i want to replace as blank (" "). is it possible by VBA.

Please guide me

heaps thanks in advance

 

[m_vishal_c]

am i doing something wrong? is there any same posting ?

 

[RoryA]

If you read the forum rules as I asked, you should be able to answer your own question.