I had a similar problem with the _global thing (But for Cells) and i
was solved when I specified exactly which workbook and worksheet it wa
from so why dont you try placing a reference to the workbook as wel
like this:

curListHV_10
WorkBooks(Name_Of_Workbook).Worksheets("Sheet3").R ange("B2").Value

Of course It might not have anything to do with it at all but this i
how I solved it.

Hope it helps.

Best Regards

Noo

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