View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
thomas donino thomas donino is offline
external usenet poster
 
Posts: 89
Default 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