Sum Cells and assign to variable

[Kitty]

I have a cell that needs to show the result of a formula.

Both the numerator and denominator are made up of a series
of contiguous cells that are not subtotaled in their
worksheets. I do not need the numerator and denominator
values; just the result.

In my VBA code, I tried setting variable Numerator=Sum
("K6:K12"), and I received an error that variable Sum
wasn't defined. I know I can add each element to
Numerator separately, but would prefer not to, if that's
possible.

Thanks for any suggestions.

Kitty

 

[JE McGimpsey]

One way:

Numerator = Application.WorksheetFunction.Sum(Range("K6:K12"))

 

[Kitty]

Perfect! Thank you so much for your help.

Kitty