DisplayAlerts = False not working for formula that points to a missing tab

my macro is putting formulas into cells which refer to cells in other files.

DisplayAlerts = False is suppressing the alert for when a file doesn't exist and just skips it and gives a #REF error.

But if the file exists and the tab I'm looking for doesn't, it pops up with the list of tabs in that file (I want it to just cancel and act the same as though the file didn't exist).

Even if I put the "DisplayAlerts = False" immediately before the "cells(...).formula = ..." it still doesn't suppress it.

Any ideas?

Here's most of my code:

Please Login or Register  to view this content.

by file i mean workbooks

and by tab i mean worksheets.

sorry if there was any confusion.