deleting range with array formulas

  • Thread starter Thread starter thomas donino
  • Start date Start date
T

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
 
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
 
Back
Top