My program is supposed to read dates out of the spreadsheet, but
sometimes there are text strings instead. On these instances I need to
write an if statement telling the program to go elsewhere when it
encounters this string. This may be really simple, but when i type
If MyDate = "TK" then
blah blah blah....


i get a mismatch error on the "TK" part. am i doing something wrong
there? what is the proper way to compare a text string to a variable.
and i know MyDate is getting the "tk" cause i had a message box pop up
to tell me the value of it right above it.

thanks