I am knowledgeable about Access VBA but new to XL VBA
I want to sum B2:B12 and display in A1. This is waht I
have:

Dim rngTotal As Range
Set rngTotal = Range("A1")


Dim rngData As Range
Set rngData = Range("B2:B12")

rngTotal = Sum(rngTotal)

I am not getting an error. What is the right way?
Thanks