Hi DredanZyl

Do you have a defined name called "Whatever" in "Personal.xls" since your
code refers to that name in "ThisWorkbook" which is the workbook executing
the sub. Do you mean "ActiveWorkbook".

--
XL2002
Regards

William



"DredanZyl " wrote in message
...
| Can anyone tell me why the very same sub gives different results when
| 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-defined
| error' when I try to run it from Personal.xls
|
|
| ---
| Message posted from http://www.ExcelForum.com/
|