Deleting cells with Array formulas gives "You can't change part of an array" error.

**NBVC** · May 1st 2018

I have a sheet with array formulas in it.

I am trying to clear or delete all the cells in that sheet via VBA code, but no matter what I have tried, it keeps giving me a run-time 1004 error that I can't change part of an array"

What can I use to just clear all the data in rows 2 and above so I can use the sheet?

a sample of one thing I tried:

Code

With Sheets("Forecast Sales")
    .Range("A2:K10000").ClearContents
End With

Code

With Sheets("Forecast Sales")
    .Range("2:10000").EntireRow.Delete
End With

Ingo_Ingo · May 2nd 2018

If range of array is say H2:L5 you cannot delete range say A2:K1000.
Verify where array formula located, select and delete all that range.

Deleting cells with Array formulas gives "You can't change part of an array" error.

Participate now!

Share