Worksheet Change when multiple rows of Data are pasted at once

[Benisato]

Good Day, I've got a piece of code that executes whenever any cell in column "F" changes. Basically what it does is it watches for any entry in column F and then it copies a bunch of formulas down from Row 1 into the target row and then updates a couple of pivot tables. I use it to keep formulas out of the document unless they are required for that line. Its a complex document, and I know the code probably isn't the most efficient way it could be done.

My concern is when a chunk of data is pasted from another document, the code only executes for the first row that changes instead of for each row.

Is it possible to have the code execute for each of the rows that was changed when the data was pasted? Are there any more efficient ways to code this so that it will run faster? This document is sometimes in excess of 8000 lines, at which point this code becomes very slow.

Any help would be appreciated.

Please Login or Register  to view this content.

[JBeaucaire]

Maybe:

Please Login or Register  to view this content.

[Benisato]

Thats perfect.

Thanks for the help!