Thread: How To Sum
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
hon123456 hon123456 is offline
external usenet poster
 
Posts: 31
Default How To Sum

Dear All,

I have an excel sheet which will be filled with data from
database dynamically, e.g.

Field_A Field_B

A 1
B 2
C 3
D 4

Now after the data has been filled, I want Excel to add a
Total sum following the last record.
just like following:

Field_A Field_B
A 1
B 2
C 3
D 4
Total 10

How can I do that in VBA?

Thanks.