It has occured a new problem...

My sheet regenerates new variables between each time something is done in the sheet. How can I avvoid this, and make it only generate new variables with the calculatefunction in VBA