Hi,
Presumably you are wanting to reference another workbook, otherwise there's be no need to specify the file name
This will work if the other file is open in memory
where FileName & SheetName are two range names that refer to cells that contain the actual file name.
Unfortunately this will not work when the other workbook is closed since Indirect won;t work with closed workbooks. A work around would be to have a macro that automatically opened the other workbook when this workbook is opened, and closes the other workbook when you close this one.
Bookmarks