Help when running code formulas on cells and in names define are changing

Hi guys

I have a code (thanks to the fantastic members here), and i dont know if its a problema with it or normal excel behaviour.
This is one part of the code in the sheet:

Please Login or Register  to view this content.

The other part is this one on module:

Please Login or Register  to view this content.

Everything is working ok until when i press the button to run the second code that divide all data in periods of time. When i run it, some formulas that i have in cells related to the range (that is beeing populated by this second code) changes the location automatic just like some names with a offset formula to those ranges are changing too.

Is there a way to avoid this but keeping the code running like it is? (just correcting this annoying problem)

Thanks in advance

So i think that i find the problema.
The second code is shifting the data to the right and every time it does that all my formulas are shifting too, just like the offsets that i have in the Names (define names).
Is there anything that could be done in the code to avoid the changes in the formulas and names?

Thanks in advance.

Anyone please