Errors in my formulas in sheet 1 when deleting data in sheet 2

In sheet1 I am using formulas which get data from sheet 2.
The data in sheet 2 is copied from another file (which contains much more data dan I need in my sheet 2).
To copy the data to sheet 2 I am using a VBA script in which I first delete all data in sheet 2 before pasting the data from that other file (otherwise the data just gets appended to the already existing data in sheet 2). The problem I now have is that deleting this data in sheet 2 affects my formulas in sheet 1. I get #REF! where my ranges used to be.
Any idea how I can avoid this ?

Thx,
Sucha

You probarbly use the code .clear to clear

try using .ClearContents

It works !

Thanks Evertjvr