Trying to avoid updating a source document when executing a FOR loop

Hi guys,

I have been developing a Macro that does multiple VLOOKUPs depending en how many variables I want to search from other document. The source document may be variable, so I define it as a Variant (you will see it in the code)

Everything seems working fine although a little issue that actually pisses me off. When the for loop executes, excel constantly asks me to update the SourceFile document by opening a browser and it makes the macro useless. I don't know any solution for this incidence. Would anyone help me?

Thanks
[SIZE=2]

Please Login or Register  to view this content.

Hi,

Please update your question to use code tags. Thanks.

You need to put [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] after it; or select the code and click the # button on the toolbar.