Hi
try something like
with activesheet.range("A1")
..formula=.formula & "+C5"
end with

-----Original Message-----
Hi,

I have developed an Excel VBA based application. I want
one feature in
the application such that to the existing formula value
of one more
cell gets added on a button click.
For example, I have a formula for Cell 1 as "=C2+C3+C4".
I have a button placed below it which when presses once
converts this
formula to "=C2+C3+C4+C5".

Please tell me if this is possible to be done
programatically.

Thanks,
Sameer


---
Message posted from http://www.ExcelForum.com/

.