Updating the cell value without losing its formula   

Hi,

I am working on excel add-in in c++.

I am using "xlSet" to update cell value , in which formula of cell is lost.

Is there any way to update cell value without losing its formula.
 
I dont want to use "xlcFormula".

Thanks in advance.

Regards,
Sunil Adhyaru.

url:http://www.ureader.com/gp/1039-1.aspx

date: Tue, 3 Jun 2008 19:59:23 +0800   author:   suniladhyaru

Re: Updating the cell value without losing its formula   

(see response to previous post).

Also, you should ask yourself why you need to do this.  I suspect that you 
can find a different way of getting the end result that doesn't rely on 
confusing cells that contain values with cells that contain formulae, which 
both serve very different purposes.

Regards

Steve Dalton


"suniladhyaru"  wrote in message 
news:99401cdda251409c84c22cf5e30a5b78@newspe.com...
> Hi,
>
> I am working on excel add-in in c++.
>
> I am using "xlSet" to update cell value , in which formula of cell is 
> lost.
>
> Is there any way to update cell value without losing its formula.
>
> I dont want to use "xlcFormula".
>
> Thanks in advance.
>
> Regards,
> Sunil Adhyaru.
>
> url:http://www.ureader.com/gp/1039-1.aspx

date: Sat, 7 Jun 2008 13:05:07 +0100   author:   Steve Dalton NOsteveSPAM(at)NOeigensysSPAM(dot)com