Skip to Content
0
Former Member
May 30, 2011 at 08:48 AM

AfterRange i SortRAnge remove formula

35 Views

Hi,

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.

Any suggestions?

Thanks,

Lars