How to search string containing quotation marks?

[osx99]

I need to perform a search for the following string within a dump of some HTML code

<td align="center"><SCRIPT type="text/javascript"><!--

I've tried to use the folowing code to implement this

Range("a:a").Select
Set tipsdata = Selection.Find(What:="<td align="center"><SCRIPT type="text/javascript"><!--", after:=ActiveCell, LookIn:=xlFormulas, LookAt _
        :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
        False, SearchFormat:=False)

However, because the search string contains quotation marks " the code syntax is not being recognised

Is there a easy way around this?

Thanks,
Os

 

[ettienne]

Yes, use double double-quotes within your search criteria to indicate a literal quote.
So your string would look something like this (untested):

Set tipsdata = Selection.Find(What:="<td align=""center""><SCRIPT type=""text/javascript""><!--"

You can also drop the quotes in some cases and it would work, so test either way.