Phillip,

Not sure what you're asking in terms of the string, but here's some
code to sum a column.

dc

Sub sum_column()

'select the range of cells you want to sum
Range("D3:D1000").Select
'activate the cell where you want to show the answer
Range("D1001").Activate
'write the answer using references rows in relation to the output cell
ActiveCell.FormulaR1C1 = "=SUM(R[-998]C:R[-1]C)"

End Sub


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements