i have a macro that assigns a cell to do :

range("E1").resize(1, 5).formula = "=E7/$AH$7"

when called it keeps the E7 reference and changes across cells as it should,
but the $AH$7 becomes AG7, then if i run again, it goes to AF7, etc etc.

I have no idea why this is happening. Any advice would be extremely helpful.

Thanks in advance