Hi Everyone,
my probleme is that when when i shift cell up using a VBA button all the formula using that cell as to do calculation become #ref! because the ref have shifted up by one cell.
The formula i use to delete and shift cell up:
Range("B6").Delete (xlUp)
Example :
i want to delete the Num1 and num2 of Obj 1 because i don't need it anymore and make Obj2 become Obj1 and Obj3 become Obj2
so i use a VBA button that will delete Num1 and num2 of Obj 1 and Shift cell up
But when i shift cell up, the ref of num1+num2 shift too.
So i want to delete and shift cell up without ref shifting up too
my probleme is that when when i shift cell up using a VBA button all the formula using that cell as to do calculation become #ref! because the ref have shifted up by one cell.
The formula i use to delete and shift cell up:
Range("B6").Delete (xlUp)
Example :
i want to delete the Num1 and num2 of Obj 1 because i don't need it anymore and make Obj2 become Obj1 and Obj3 become Obj2
so i use a VBA button that will delete Num1 and num2 of Obj 1 and Shift cell up
But when i shift cell up, the ref of num1+num2 shift too.
So i want to delete and shift cell up without ref shifting up too