Format

  • Thread starter Thread starter Kathie
  • Start date Start date
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,
 
Hi Kathie,
seems straight forward to me, what problem did
you have when you tried it.
 
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.


"Kathie" <[email protected]> wrote in
Click to expand...
message news:[email protected]...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Variable SUM range 16
Sum number range ignoring numbers formatted as text 0
How to delete ALL cells containing the same data 1
userform exception error 4 textboxes 7
pick out arguments from formula 1
VBA Linest function for polynomial regression on horizontal range 0
Setting formulas with R1C1 in VBA and eliminate $ 6
Conditional Sum 1

Back
Top