Thread: Change formula by using a referrence from other cells.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JRForm JRForm is offline
external usenet poster
  
Posts: 130
Default Change formula by using a referrence from other cells.
Issue resolved.

"JRForm" wrote:

I would like to use code or a formula to change this formula:
'C:\Program\Monthly\2006\[06 My File.xls]SUMMARY'!D7
If I have a cell with the directory path and one with the file name, is
there a formula or code to change the formula in a range of cells?

Thanks
Reply With QuoteReply With Quote