VBA - Help with Worksheet.Change

Sup,

Guys, Im having some troubles with this function "worksheet.change". I need a macro to run when a cell - A1 for example - changes. This cell(A1) takes some seconds to get changed because its linked with another data base which comes from an online website. So it takes at least 5 seconds to copy all the information from the other base to this plan with all the macros.

My problem is: I cant set a correctly code to run exaclty when this cell "A1" has changed. Using my current code, after it has copied all the data from the website the macros doesn't run.

And if i call them as soon as I open the plan, there's not enough time to bring the data correctly and so screw up everything.

If you guys know some way to do it right, even with not with "worksheet.change", please tell me.

Thanks

About the code, I was using it with "_". Sorry , i've wrote it wrong up there.

The data is being copied by an Excel code that is also provided by the site, It's something like this:"=QTLINK("SERIES";"ARGUMENT_X";"ARGUMENT_Y")"; Every time I open this plan, this code updates me some data from this website and so copies to the plan. My problem is that I can't make excel wait while it is happening. I've tried everything that I knew but nothing solved it, sometimes it runs all the macros before the data had been sucessfully copied to the respective cells running it wrong. Otherwise, It waits all data copying but doesn't run all the macros after it.

Got it? In short call -> VBA has to wait until my first code copies the data then run all the macros. The code I was using to make it wait doesn't work, so there's no point sending you this.

If you could suggest me a way out of this I would be really, really thankful.