macro error
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 |
macro error
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 |
All times are GMT +1. The time now is 10:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com