Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula
Does anyone know the vba code to show a summation in an
excel formula as =SUM(A1,A2,A3,A4) --- the only ones I know show up as =SUM(A1:A4) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula
the VBA code is exactly as you wrote it.
But, as long as you are in VBA, why would you want to do it that way? Why not: Total = 0 For i = 1 to 4 Total = Total + cells(i, "A") Next -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula
"MSP77079 " wrote...
the VBA code is exactly as you wrote it. But, as long as you are in VBA, why would you want to do it that way? Why not: Total = 0 For i = 1 to 4 Total = Total + cells(i, "A") Next i Perhaps either Total = Evaluate("SUM(A1:A4)") or Total = Application.WorksheetFunction.Sum(Range("A1:A4")) run more quickly than your For loop. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |