View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gappodi Gappodi is offline
external usenet poster
 
Posts: 1
Default Replacing DirectPrecedents in a Formula

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