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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Baffled with assignment of range to array why won't it work??? Anyhelp appreciated 4
Copy Array to Array, how to and should I? 13
CSE with function returning an array? 2
Format of Cell with Array Formula - Using VBA 2
Cell values to an array, then array transpose to another workbook 8
Arrays and scattered cell values or another way? 16
copying an array formula 2
Permutations andText to column problem 6

Back
Top