Using Range variable in =sum formula

Please Login or Register  to view this content.

Above is the part of my code I'm having troubles with.
As you see, I'm having a selection and I want a =sum formula based on the selection, next to it.
It gives me the runtime error 1004, Application-defined or object-defined error, and marks the last line.

I thought that adding .Address to my range-variable would do the trick, but after some searching and other tries I realise I don't know what little tweak is needed to do this.

In the end it will be part of a loop, but that shouldn't be a problem as soon as this is fixed.

Kind regards.

Perhaps

Please Login or Register  to view this content.

This worked exactly as I needed. I thought I tried that earlier, but I might have done some of my code improperly. It is fixed now and I can continue.

Thank you so much, Erwin.