Public Function Get_dir()

Windows("PEM.xls").Activate

With Worksheets("sheet1")
.Activate
Get_dir = .Range("H1001").Value
End With

End Function

can anyone help me figure out what does this function do ? especiall
the line Get_dir = .Range("H1001").Valu

--
ReD-DevI
-----------------------------------------------------------------------
ReD-DevIL's Profile: http://www.excelforum.com/member.php...fo&userid=3262
View this thread: http://www.excelforum.com/showthread.php?threadid=52426