Is there a way to avoid #Ref error when the sheet/ref does not exist/is removed?

[pedie]

Hi, is there a way to avoid #Ref error when the sheet/ref does not exist/is removed?
kind of formula i'm referring to
'=SUM(A1,Sheet2!A1,Sheet3!A1,Sheet4!A1,Datas!A1)

When sheets "datas" for example is removed/deleted it errors back as #REF

Thanks in advance for helping.

 

[shg]

I'm pleasantly surprised to show you something you didn't know, Domenic. I have learned a ton from you on forums over the last five years.

Cheers

 

[Domenic]

I'm pleasantly surprised to show you something you didn't know, Domenic. I have learned a ton from you on forums over the last five years.

Cheers

Oh... there's plenty I don't know. It seems that there's always something new to learn. Especially when it comes to VBA.

Cheers!