Editing multiple array formulas and maintin cell references

[Cris4py]

Hi

Hopefully you can help me. I would like to find a way to edit a number of array formula cells, simultaneously, adding in a data range name but retaining the other cell references. Currently I can select multiples, add in the data range name and when I press Ctrl+Shift+Enter it changes the other elements of the formula to the same values.

As an example;

In D12
{=IF(ISNUMBER(MATCH(1,IF(D7>=HFrom04,IF(D7<=HolTo04,1)),0)),"H","")}

in E12
{=IF(ISNUMBER(MATCH(1,IF(E7>=HFrom04,IF(E7<=HolTo04,1)),0)),"H","")}

in F12
{=IF(ISNUMBER(MATCH(1,IF(F7>=HFrom04,IF(F7<=HolTo04,1)),0)),"H","")}

What I want to be able to do is select all the cells simultaneously, change "H" to the named data range Activityxx, and retain everything else, as is,in the formula (e,g, not have the D7, E7, F7 all be the same value.

Thanks for your help, this ones driving me crazy and without a solution, i've got to individually edit hundreds of fields / formulas.