Ignore the 'select sheet' dialog and continue loop?

[mountainman88]

Im using some code to generate formulas in cells on a sheet, some of the formulas generated are links to worksheets that do not exist, this means that once the formual is inserted I get the select sheet dialog box come up.

Is there a way I can ignore this and continue creating the formulas even though they have no valid link?

I tried On error resume and displayalerts = false but no luck

Thanks!

 

[johnnyL]

Did you try?

Application.AskToUpdateLinks = False

 

[johnnyL]

Are you sure that worked for you?