Change formula by using a referrence from other cells.

's Computer Specifications

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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
pull in cell text to referrence sheet name in formula	dsweeney	Microsoft Excel Programming	3	1st Sep 2009 07:36 PM
change color of all cells with formula or are part of a formula	everythingautomotive@gmail.com	Microsoft Excel Misc	19	28th Jan 2008 01:21 AM
Change the color of cells having formula.	=?Utf-8?B?QXJ1cCBD?=	Microsoft Excel Misc	5	2nd Nov 2007 10:50 AM
Change cells color & cells contains if formula	dot	Microsoft Excel Programming	1	24th Jan 2006 01:34 PM
Is there a way to transfer a style by cell referrence in a formula	=?Utf-8?B?Qmlua2k1NV9DYW5Zb3VIZWFyTWVOb3c=?=	Microsoft Excel Misc	1	30th Nov 2004 06:08 PM