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

  • 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
    1. With Sheets("Forecast Sales")
    2. .Range("A2:K10000").ClearContents
    3. End With


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

    Where there is a will there are many ways. Finding one that works for you is the challenge!