Can anyone tell me why the very same sub gives different results whe
run from the Personal.xls workbook? Here is the code:

Sub VLookUpRange()
Dim rName As Name
Set rName = ThisWorkbook.Names("WhatEver")
End Sub

This sub works fine with all workbooks except Personal.xls.

I get the 'Run time error 1004 - application defined or object-define
error' when I try to run it from Personal.xl

--
Message posted from http://www.ExcelForum.com