Gap,

I'm not sure exactly what your question is. DirectPrecendents is a
read-only property, and any change in the would need to be done by changing
the cell references used in the formula. Depending on your specific
situation, you *might* be able to use the INDIRECT function to accomplish
what you want, but without more information, it is impossible to say.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Gappodi" wrote in message
om...
Hello,

I need to copy a formula to a different sheet where the
DirectPrecedents positions are different. I can get the
DirectPrecedents from the source using the DirectPrecedents property.
I have the corresponding mapping of these DirectPrecedents in the
target.

Is there a way using the Excel Model to replace these DirectPrecedents
using the mapping I have or I have to parse the source and modify the
target accordingly.

Thanks and Regds
Gap