View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
steven steven is offline
external usenet poster
 
Posts: 389
Default 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