Links w address function.

  • Thread starter Thread starter Allen
  • Start date Start date
A

Allen

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)
 
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)
 
Back
Top