Referring to named ranges (again)

I got some assistance before on referring a single named cell in some VBA code. Based on that I've now a piece of code that looks like:

Please Login or Register  to view this content.

Which appears to fail miserably. Method 'Range ' of object '_Worksheet' failed. This code is contained in a Worksheet_Activate event for a particular sheet. While the named range is not on that sheet it is workbook level (I can type in "+country" anywhere and get an answer).

Is there some difference with using this code at an event level rather than in a normal moduel that I am missing?

In a worksheet code module, Range refers to that worksheet unless otherwise specified. You should be able to just use Application.Range instead of Range, or use ThisWorkbook.Names("country").RefersToRange to be safe.

Worked a charm. Thanks very much.