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

AH7 stayed constant for me as expected.

--
Regards,
Tom Ogilvy

"Monique" wrote in message
...
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