Adding numbers continously in multiple cells

[KMF]

Thanks, is it possible to use the formula below in more
than one cell? I would like to add several items in
different cells on one worksheet and have them added
(accumulated) in designated cells in another worksheet.

 

[Jonathan Rynd]

Thanks, is it possible to use the formula below in more
than one cell? I would like to add several items in
different cells on one worksheet and have them added
(accumulated) in designated cells in another worksheet.

Yes, just add more "If target.address = "" then - end if" blocks before the
end sub.