deleting range with array formulas
 

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

deleting range with array formulas
 

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


"thomas donino" wrote in message
...
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