I've "cleverly" written an array formula using a user defined function which
is implemented across several columns.

Now I want to (programmatically) delete some columns in the worksheet
according to certain conditions. Unfortunately I get an error message saying
that I can't change part of an array.

Do I have to seek out these rows, save the array formula (somehow), delete
the array formula, delte the columns, and re-create the array formula? or is
there something simpler?

Array formula is like {=myfunction(A10:j10,A43:j43,b1)}

REgards

Les
--
Les Gordon