Accumulator Macro - working but needs expanding

[sipa]

Hello Excel Guru's

I found the following sheet change event accumulator macro, this does work fine on a single row, if a little slowly.

How could this be made to work on say, 100 different rows, different data on each row ?

Please Login or Register  to view this content.

[protonLeah]

Maybe partial solution:

Please Login or Register  to view this content.

[sipa]

Thanks for that. I'll have a go with your code and report back.