Thread
:
Concatenate a formula
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
steven
external usenet poster
Posts: 389
Concatenate a formula
="'C:\Accounting\Files\[" &H5& ".xls]Sheet1'!$I$6"
Will return this in the cell.
C:\Accounting\Files\[Accounting1.xls]Sheet1'!$I$6
But not the value of the cell I6 which is what I want.
Thank you,
Steven
Reply With Quote
steven
View Public Profile
Find all posts by steven