Formula Problem

Q

Question Boy

Hello,

I am, through the use of vba, dynamically building a table from data in a
text file. Then I add at the bottom of the table an extra row to calculate
the summation of the values.

Values
($2,431,509)
$183,526
$0
($2,020,596)

Summation
($1,837,070)

My summation is entered as 'Selection.InsertFormula Formula:="=Sum(Above) \#
" & Chr(34) & "$#,##0;($#,##0)" & Chr(34)'

and yet it is not including the 1st value in the summation (the summation is
erroneous). Anyone have any ideas as to why or how to get around the problem?

Thank you,

QB
 
H

Helmut Weber

Hi Question Boy,

I'm no good at fields,
so I won't comment on it,
but the summation isn't just erroneous,
it is value (4) minus value (2).

I wonder.
Values
($2,431,509)
$183,526
$0
($2,020,596)

Summation
($1,837,070)
Click to expand...

--

Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Vista Small Business, Office XP
 
Top