Format

K

Kathie

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,
 
D

David McRitchie

Hi Kathie,
seems straight forward to me, what problem did
you have when you tried it.
 
K

Kathie

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" <[email protected]> wrote in
Click to expand...
message news:[email protected]...
 
Top