Formula with excel range

Range("A1").Precedents.Address
--
HTH...

Jim Thomlinson


"prasanta" wrote:

> Hello,
>
> I have a problem with the Excel Cell formula. I want to extract the
> what are the referance cell for a particular formula.
> Like if I use :
> <range>.Formula
> Its return something like(depend on formula)
> 1) =SUM(A1:A3),
> 2)=A1+A3,
> 3)=A1+A2+A3,
> 4)=A1*SUM(A2:A3).
>
> So, is there any built in function or types in C#.NET through which i
> can eassily get the referance cell.
>
> Please Reply me.
>
> Thanks,
> Prasanta
>
>

Hi Jim,

In range object there was no property such like this address i m geting
upto this Range("A1").Precedents, but i m not getting Address, so
please tell me where i can, i m using office 2003 with windows 2003 and
VS 2005.

Thanks,
Prasanta

Jim Thomlinson wrote:
> Range("A1").Precedents.Address
> --
> HTH...
>
> Jim Thomlinson
>
>
> "prasanta" wrote:
>
> > Hello,
> >
> > I have a problem with the Excel Cell formula. I want to extract the
> > what are the referance cell for a particular formula.
> > Like if I use :
> > <range>.Formula
> > Its return something like(depend on formula)
> > 1) =SUM(A1:A3),
> > 2)=A1+A3,
> > 3)=A1+A2+A3,
> > 4)=A1*SUM(A2:A3).
> >
> > So, is there any built in function or types in C#.NET through which i
> > can eassily get the referance cell.
> >
> > Please Reply me.
> >
> > Thanks,
> > Prasanta
> >
> >