If you close the workbook that the Get_Sheet variable is pointing to, the
reference is destroyed. So what are you trying to do exactly?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Mac Lingo" wrote in message
.com...
I call the following function. It gets the correct Sheet in the
function, but the argument that Function passes
in
Set VARIABLE = Get_Sheet(...)
says "<No Variables" when I look at it in "Watch".

Function Get_Sheet(DirName, FileName, SheetName) As Worksheet
Workbooks(DirName, FileName).Open
Set Get_Sheet = Workbooks(FileName).Sheets(SheetName)
Workbooks(FileName).Close
End Function ' Get_Sheet


Any idea it doesn't work?


Tnx, Mac
Berkeley, CA