Search dependent on cell contents

Hi All,

I have a line of code which I want to search against a particular string in a certain cell ('Front Form'!$C$2) which has a month contained within it. This month changes depending on buttons used which runs a macro, changing the month displayed there.

The code I have for the search itself (after recording a macro) is:

    Cells.Find(What:="Nov-08", After:=ActiveCell, LookIn:=xlFormulas, LookAt _
    :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
    False, SearchFormat:=False).Activate

Is there anything I can use inplace of "Nov-08" which will stipulate search for the contents of 'Front Form'!$C$2 ?

Thanks in advance,

Mr Pan