Links w address function.
 

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

Links w address function.
 

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

Links w address function.
 

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