Unfortunately I don't use the function because this issue is part of a bigger php macro writing data to the db.
This code snippit is part of the confirm-button writing submitting the data. The final step for this button would be to reset the _auswahl-Array to default which is zero.

Finally I found a solution which is pretty ugly.
I collect the values in AB77 in an array using a named range in the sheet.
Next I iterate through the array searching for "1" as values to set them to 0 by knowing the DynaRange starts at column AB and row 77.

Here is the code:

PHP Source Code

$awb = activeworkbook();

//named range containing the

$auswahl = $awb->names->item('_auswahl ')->value;

for ($i = 0; $i <= count($auswahl); $i++) {

if($auswahl[$i] == 1) {

$row = 77 + $i;

$cell = "AB" . $row;

ActiveSheet()->Range($cell)->value = 0;

}

}

If there is any chance to get the information about where the _auswahl-range starts dynamically by macro that would be great because I really don't like the code above.