Hi

I need to calculate SUM of selected cell range e.g.

PB YU Bud PBud Actual TC
Sam 120 130 190 130 150
James 130 150 110 120 130
Raj 150 120 120 100 120
=================================
Total 400 400 420 350 400

How to calculate the total using Ms Access VBA? Also to how draw "=====" line?