ExcelBanter - Change formula by using a referrence from other cells.

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Change formula by using a referrence from other cells. (https://www.excelbanter.com/excel-programming/399175-change-formula-using-referrence-other-cells.html)

JRForm

Change formula by using a referrence from other cells.

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

JRForm

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

All times are GMT +1. The time now is 10:01 PM.