Adding and deleting rows will change your applies to range, i dont think there is away around this.