is it possible sum scattered cells which is selected?

[ABDELFATTA]

hi all
i'm asking about if is possible sum every scattered cell which is selected for instance if i have some values in d11=34 , e13=1 , m15=10 then show sum in j22 =45
thanks advance

[MarvinP]

Hi,

Do you want in J22:

Please Login or Register  to view this content.

[Crooza]

Change your private sub to this

Please Login or Register  to view this content.

[ABDELFATTA]

hi, crooza it's perfect can you add message to show the result sum

[ABDELFATTA]

thanks marvinp for the formula but the code is better i don't have to change range every time when i sum different cells