Showing Run-time error "1004" when executing code with thousans of data

Hi all
I am trying to copy the stock price from Yahoo Finance.
In the beginning, i can import it to the worksheet easily with 3 years of data.
But the "1004" run-time data is shown when i copy the data with 8 years.
Could someone know what is the problem and how can i fix it?
Thanks

Here is my code.

Please Login or Register  to view this content.

Could anyone help me to solve this??
Thanks a lot.