deleting range with array formulas

[thomas donino]

Hello all,

I am trying to delete a range which has historical stock data from an array
formula. I want to reformat the cells in the range and then I will reinsert
the formula. No matter what I do i get this dialog box;"You cannot change
part of an array". Are those cells stuck there for good? How does one delete
that range?

TY

 

[Bernie Deitrick]

Thomas,

Select one cell with the formula, then use Edit / Go To.... Special select "Current array" and
press OK, then press Delete.

HTH,
Bernie
MS Excel MVP