Hi,

especially this line returns the value of cell "H1001"

if you run a line like msgbox get_dir() you´ll get a message-box which shows
you the value of cell H1001

best regards


"ReD-DevIL" schrieb
im Newsbeitrag ...

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 ? especially
the line Get_dir = .Range("H1001").Value


--
ReD-DevIL
------------------------------------------------------------------------
ReD-DevIL's Profile:
http://www.excelforum.com/member.php...o&userid=32624
View this thread: http://www.excelforum.com/showthread...hreadid=524267