So here's the problem.
I have a template in which I have 2 cells with vlookup formulas that point to a fixed range (with the $) on a help sheet.
Now the macro pulls in data from another sheet on to this help sheet onto the fixed range that is used in the formula.

However the data which is copied has empty columns between the filles columsn.
With a piece of vba code I take this empty columns out and the lookup range is back to its original state again so no worries I thought.

However the vlookup formula reacts on this deleting of empty columns by adjusting my (fixed) lookup range.
So ie at start the lookup range is $G:$T and after is $G:$N and antother run of the macro brings it to $G:$H.

Normally I welcome this excel inteligence of adjusting your formulas when you delete rows, columns or move things.
But this time it is certainly not welcome.

I tried with :
Application.Calculation = xlCalculationManual
Application.Calculation = xlCalculationAutomatic
And then the deletion of the empty columns between turning off and on the calculation.

But this wont do the trick....

So is there also code to disable the automatic updating of formulas?
And as above I am not refering to automatic calculation of the formulas because that is something different.
Thanks.