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
|