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:

Please Login or Register  to view this content.

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