| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Not able to copy a VBA array with formulas into an Excel range | Excel Programming | |||
| Restoring formulas after deleting range names | Excel Worksheet Functions | |||
| Isolate array formulas in a range | Excel Programming | |||
| Array Formula Not Working with Range with Formulas | Excel Discussion (Misc queries) | |||
| How to activate array formulas in a range of cells all at the same time? | Excel Programming | |||
Hybrid Mode
