Streching cells using worksheet_change

Hi all, I have a problem using Worksheet_Change. The code is the following:

Please Login or Register  to view this content.

The problem arises when I put a value in one of the target cells (a1:a5) and I try to extend the same value with the common "streching" trick with the mouse. It gives me code error no. 13: type mismatch. Can someone explain it?
Thank you very much

Add this at the top and it will avoid the error

Please Login or Register  to view this content.

Yes cool trick! thanks!

..but can I also run the code for each cell modified with stretching?

Yes, perhaps better to loop through like so

Please Login or Register  to view this content.

That's perfect. Thanks again!