Before I got your last reply, it had occured to be it should be End Function.
And then it worked.

Many thanks for your help. It does precisely what I needed.

"Bernard Liengme" wrote:

I added "Exit Sub" as an afterthought; it should, of course, read "Exit
Function"
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Dkline" wrote in message
...
I am importing an XML file into a workbook. I then need to find
"bridge_CompanyName" and "value_GuaranteedCashValue".

The trick is I don't know from one XML to the next where these keywords
will
be. I'm trying to use the MATCH function on another worksheet to tell me
where these two keywords are on the worksheet. One example has the
"bridge_CompanyName" in R2C7 and "value_GuaranteedCashValue" in R42C9. The
next example has the "bridge_CompanyName" in R9C11 and
"value_GuaranteedCashValue" in R50C13

I'm using the MATCH function. =MATCH("bridge_CompanyName",Sheet1!
R1C1:R972C25,0) and =MATCH"value_GuaranteedCashvalue",Sheet1!
R1C1:R972C25,0)
but both are returning #N/A. All three match_type options return #N/A.