If condition...

[ap1]

I want to blank out contents of column if the date is 9999-12-31 and i want to keep other dates intact. Could some one help me with this please?

 

[paelinck]

Simply use a Find and Replace (Edit - Replace) for the date mentioned, keeping the "replace with" field empty. In the "find what" field, you should type the date exactly as it appears in the formula bar.

Marc

 

[ap1]

may be this is very simple question to ask but can anyone tell me please.

 

[ap1]

but i am doing this within a macro. is there a simpler way to do it by selecting the whole column

 

[paelinck]

You can do the same from a macro:

MyColumn.Replace What:="12-31-9999", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False

where MyColumn is the range you want to scan.

Marc

 

[ap1]

Thanks