Excel array formulas
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
|