Hi all
In my procedure I have a loop that, at a certain point, makes a named range.
The code I use is:
Later on in the procedure I use this (in this case) profitcenterCell in a formula that is defined in the code.
My goal is that in loop 1 the cell reference in the formula is (e.g.) $B$2, in the second loop $L$2, 3rd: $V$2 etc
My formula:
The 1st time the code runs (reference $B$2) it runs OK
The other times it doesn't
The problem is that the cell ProfitCenterCell changes location, also disrupting the 1st loop
How can I change the last formula so that it doesn't refer to ProfitCenterCell but to $B$2 in the first loop, in the second loop $L$2, 3rd: $V$2 etc.?
Thanks in advance
Hein
Bookmarks