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