AfterRange i SortRAnge remove formula
I'm using an AfterRange in the SortRange in an input schedule. For the data area i'm using EVSUB (works fine), but for the text I would like to use a formula giving me the correct rowtext for the row. The formula referance a cell where the appropriate text is shown.
After expansion the formula for the rowtext disappear and the AfterRange cell (in the input schedule) shows the result of the formula where the AfterRange lines are defined.
Doing the same trick without a SortRange works fine. Here the formula is copied as expected.