L
Legacy 57334
Guest
I have three columns with data as follows:
01/09/2007 | 5 | 06/09/2007
| 4 | 01/01/1900
If the value isnt set in column A then Column C shows this dummy date value.
I have some VBA which is serching for the data in ColumnC and exports it. The problem is that i want it to export "Unknown" if the default is displayed. How can i do that?
I tried an If/ElSE statment and used wildcards as "??/??/1900" but that didnt work.
Thanks
Joel
01/09/2007 | 5 | 06/09/2007
| 4 | 01/01/1900
If the value isnt set in column A then Column C shows this dummy date value.
I have some VBA which is serching for the data in ColumnC and exports it. The problem is that i want it to export "Unknown" if the default is displayed. How can i do that?
I tried an If/ElSE statment and used wildcards as "??/??/1900" but that didnt work.
Thanks
Joel