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