I have one issue which I can't solve by myself.
Recently, (I'm new in VBA, but advancing well) got this particular problem:
while performing a 3D sum in workbook that contains sheets that are named by the week number, I used a macro that removes the sheets named "Start" and "End" to a proper position in the workbook, so I can use the formula: =SUM(Start:End!A1). The sheets DO go to preferred positions and that is not an issue. But for next range, when I change the week range using the macro, the above formula changes, and becomes like =SUM('Start:15'!A1), where 15 is the position of the previous position. Changing to other sheet, doesn't change the formula further, so it stays 15, no matter what.
I don't know how the changing of the position of the tab affects the formula in a different cell. The macros are not in any touch with the cell that is performing the calculation.
I made all this, because I understood that 3D sum is not possible using indirect function, so ended up with this solution. Looks fine, but when changed, performs wrong calculation.
Thank you in advance.