How to replace a sheet that has formulas linked to it, without REF-errors?

Hi! The issue is the following:
I have a workbook with several sheets. One of them contains a central table with data, "Depoes". On several other sheets I have formulas that is connected to the sheet "Depoes".
What I am trying is to do, with VBA, is to DELETE the sheet "Depoes", and then replace it with a NEW copy, from "THE MASTER WORKBOOK", where the sheet "DEPOES" is updated.

The sheet removal, and retreival of a new copy is working fine. The issue is the formulas, they don't like it, when the sheet "Depoes" is deleted, so I get "REF-errors".

I tried to replace the "Equal sign" in the formulas with the "fool-proof-code" of "ZZZXZZZ", before doing the deletion and retreival of the new copy, but using REPLACE in VBA, after that, replacing
"ZZZXZZZ" with "=" will NOT work......probably since I am trying to create a formula out of a string......

Anybody has any ideas?

Best Regards from Sweden
Bj顤n

Thx M8! I will give it a go, sounds good!

Hi ! Problems solved! Thx!
Another question in the same area.....regarding the retreival of the tab from the master Worksheet that I described above.....
The master worksheet is on a Sharepoint-sight and the code that I have works sometimes, and sometimes it doesn't...... :-(
When It doesn't work, it always stays at the same line....with a "Subscript out of range"-error.....which is a natural error, since the retreival hasn't kicked in.....

I enclose the code below......the part that doesn't work is when the sharepoint-worksheet shout be found, and opened.....the code DOESN'T find it somestimes....and sometimes it does.....???
(That part is on the row "directory........."
Is there somethisn special I need to do, to get the code to really search the adressed folder.....the file IS present.....any special references I need to set? Or...?

Please Login or Register  to view this content.

Best Regards!
Bj顤n

I have no experience in using VBA to work with files over a network or with SharePoint. I don't know why this problem is occurring, and not sure how to troubleshoot. But this question is so completely different than your first question, you might get better help if you start a new thread with a title like

Intermittent error with workbook opened from SharePoint

You're so right.....thanx!!