Hi,

I would like to use the name in the C4 in Sheet1 as my source file as
xls file.
I have written a macro but have error. Attached please find the macro.

Anyone can help.

Thanks.


Sub Macro1()

Range("K10").Select
ActiveCell.FormulaR1C1 = "=[Sheet1!C4.xls]LeakFreq!R39C4"

End Sub


--
ccl28
------------------------------------------------------------------------
ccl28's Profile: http://www.excelforum.com/member.php...o&userid=36095
View this thread: http://www.excelforum.com/showthread...hreadid=569812