Naming Ranges or Not

[dmkitz]

I created two financial forms, in Excel. Formulas in Form B take values that exist in Form A and populates cells in Form B.

This is code from Form B:

 
=IF('G:\FormA.xls'RE1Add1="","",'G:\FormA.xls'RE1Add1)

You notice that instead of using generic cell references, I named the cells. This is creating a problem now if the user needs to add rows to a particular section because they cannot just copy the formula down, because Excel copies the exact range names down.

So do I have a choice but to go back and unname those cells? Is there a way to substitute cell references for cell names in a formula?

[lucas]

dmkitz,
I moved your thread to an appropriate forum. This will increase your odds of getting help with your question.

[ALe]

have a look to this kb
http://vbaexpress.com/kb/getarticle.php?kb_id=675