Search for prior month date in a range

Hi Guys

I'm trying to establish whether or not excel can find a prior month's date in a spreadsheet. What I have is the below;


FileYear = Year(Date)
strFileMonth = Format(DateAdd("m", -1, Now), "YYYYMM")
FileDate = Format(Date - 1, "dd.mm.yyyy")
FilePath = "L:\ClientInterest\CI shared\~ Month End Interest Process ~\Monthly Rates\" & FileYear & "\" & strFileMonth & "\*FX Rates*.xlsx"
RateMonth = Format(DateAdd("m", -1, Now), "dd.mm.yyyy")
Dim strFindWhat As String
strFindWhat = RateMonth


Windows("KPI Interest 2015 - FULL FILE (CLIENT INTEREST)_DUMMY.xlsx").Activate
Sheets("Rates").Select
Rows("1:1").Select
Search("" * strFindWhat * "", After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Select

However it keeps falling over at the search part. Can you help me resolve?

Tks!

Freddie