Checking if a property contains another specific string

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

hugehead - 13 Sep 2007 16:26 GMT

I am trying to see if a defined name's RefersTo property contains a
particular string.
To be more specific, I am going through the defined names in the workbook
and checking if any of them are pointing to a particular file path or a
worksheet.

Any pointers would be appreciated.

Jay

Reply to this Message

Tom Ogilvy - 13 Sep 2007 17:52 GMT

for each nm in activeworkbook.names
if instr(1,nm.Refersto,"book1.xls",vbTextcompare) then
msgbox nm.name & " " & nm.Refersto
end if
Next

Signature

regards,
Tom Ogilvy

> I am trying to see if a defined name's RefersTo property contains a
> particular string.
[quoted text clipped - 5 lines]
>
> Jay

Reply to this Message