Script overwrites the last paste action (possible simple question).

Dear Excel-specialist,

I have a short question. I have a script that:
- Searches through all worksheets in a workbook
- Copies the text from the A3 position (range) until a cell value is found with the value ="END"
- All copied text (range) will be paste in the "planning summary" worksheet

What happens is:
I only see the past results of the first two lines from and below A3. The last copy/paste action is correct. Then I see the whole range.

Does somebody knows what I am doing wrong?

Please Login or Register  to view this content.

Works like a charm! Thank you (add reputation is done) :-)