I am trying to find a date within a row of dates. The dates are actually
calculations(a series), formatted to read as dates. The other rub here is
that becasue of the calculation the day of the month is varied since the
original creator of the spreadsheet adds 32 to the previous date. (Oh by the
way the date is formatted for Canada and not the USA which means the month
and day are reversed)

So can I use * or must I use a function to convert the date calculations
beofre I do a Find

I typically use:
ColRef2 = xlApp.Rows(5).Find("1/1/2005").Column

But it is not working since the day value is not "1" but rather a number
other than "1". SO I tried the following without any success
ColRef2 = xlApp.Rows(5).Find("1/*/2005").Column