Assing result from httpRequest to adequate cell,optimising the working code

[4evra]

Hey there.
I wanted to make a code that automates extracting some specific data from web to excel,and i managed to do it thanks to resources online(found most of code,added/tweaked a bit)

Anyways,in an effort to better understand the VBA optimising,as well as to speed up the code itself,i was wondering if any kind of optimisation is doable on this code:

Please Login or Register  to view this content.

Code does exactly what its supposed to.I can explain the use and purpose of it further if needed.
I was unable to specify directly what data i needed to take from a transfermarket page,so i loaded all hyperlink texts,then saw that the data i need appears at A30 cell,and took it 'manually".


Thanks in advance

[4evra]

My appologies.
My code is already working,so there isn't actually a problem,i was just looking at an opinions from more experienced coders about my implementation of it,so i could learn to improve the code and the whole process of me coding,so the code is more to the point and better optimised.
I did change the title thread,as you instructed.