wild window appears

[MarieBocc]

Hello everyone,

I am facing a problem I never had so far while using vba : a specific lign of code bloc the programm and make a window appear but it is supposedly not supposed to do so. The window isn't an Excel control or anything, just a normal file directory's window asking me to select a file in order to "update values". I have no idea of what this is supposed to mean and I really don't think I am supposed to get this because the ligns in question are as follows :

[FONT=Verdana]Cells(myRow, 1).FormulaR1C1 = "=IF(OR((RC[5]<>""""),(RC[3]<>""""),(RC[2]<>"""")),LOOKUP(""zzz"",R9C[1]:RC[1]),"""")"
[/FONT]

which only purpose is to set the formula in the cell (17 for instance) as "=IF(OR((H17<>"");(F17<>"");(E17<>""));SEARCH("zzz";B$9:$B17);"")
but certainly not to cause the other window to appear !

Does anyone has ever encountered this problem or has any idea ?

Thank you for reading,

Marie

 

[Fluff]

As your formula is going into column A it's
=IF(OR((F17<>""),(D17<>""),(C17<>"")),LOOKUP("zzz",B$9:B17),"")
So are you looking at the wrong cells?
If you are being asked to "Update values" it sounds like you have links to another workbook.

 

[MarieBocc]

Turned out I had lost connexion with the company's servers and the computer couldn't find the path to the Excel file I was working on. The macro could still run without sending any error message so I hadn't realized.

Thank you for taking some of your time to give me an answer !

 

[Fluff]

Glad you sorted it out & thanks for the feedback