Function works fine but after excecution formula is deleted from cell

Jun 21, 2013 at 9:26 AM
I created a custom function which is constructing a text and it is placing it in another cell (targetRange defined as parameter). This is work fine except in a macro-enabled excel. For this excel targetRange is updated with the correct text and format but the formula from the original cell is deleted.
Jun 21, 2013 at 9:42 AM
Found the problem... There was a SheetChange event from another AddIn messing with the value of the source cell