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
Bookmarks