View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kev[_6_] Kev[_6_] is offline
external usenet poster
 
Posts: 7
Default Total Value of a Range


Hi

could anyone help. I need to calculate the total value of a range of
cells, say B2:B10. Then place that total into another cell, say A1.

I need to do this using VBA with placing or displaying formula in the
sheet at any time.

thanks in advance

regards Kevin


*** Sent via Developersdex http://www.developersdex.com ***