I want to link sheets with cell references and file names as
parameters. I tried address function but it did not work.

Cell a1 would be the file and sheet name /excelfile.xls!sheet1

second file would just type the filename and the range.

TY

Allen

Use the indirect function, but this only works if the workbook being linked
to is open. (in the same instance of excel)

--
Regards,
Tom Ogilvy

"Allen" wrote in message
om...
I want to link sheets with cell references and file names as
parameters. I tried address function but it did not work.

Cell a1 would be the file and sheet name /excelfile.xls!sheet1

second file would just type the filename and the range.

TY

Allen

Try the INDIRECT function, but only on open workbooks

=INDIRECT(A1&"$BE$8")

but A1 shou8ld be in the form '[excelfile.xls]Sheet1!'.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Allen" wrote in message
om...
I want to link sheets with cell references and file names as
parameters. I tried address function but it did not work.

Cell a1 would be the file and sheet name /excelfile.xls!sheet1

second file would just type the filename and the range.

TY

Allen