There is not a problem with the original code, I just want
to know how to change the way the formula is displayed on
the Excel worksheet (through the vba code). I would like
it to show up as =SUM(A1,A2,A3,A4)




-----Original Message-----
Hi Kathie,
seems straight forward to me, what problem did
you have when you tried it.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed
Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm

"Kathie" wrote in
message ...
Hello,

This code presents my information as =SUM(A1:A10)
in Excel.

Range(targetcell).Formula = "=sum(" & cum & ")"


Is there a way to change the format to show the
information as =SUM(A1,A2,A3,A4)


Thank You,


.