----- Purpose. Select the range you want to delete all data but formulas press Ctrl G keys simultaneusly to open the Go To. If the formula is an array formula you must first select.
A client of mine has to upload a new version of this Excel document each day the calculations change daily so the simpler the solution the better.
Learn how to remove excel a formula from the Excel document and keep all the dataDont forget to check out our site httphowtechtv for more free how-to v. Delete table data and keep table formulas ----- Sub deleteKeepFormulas Dim tbl As ListObject Assign table to a variable Set tbl ThisWorkbookSheetsExampleListObjectstblExample Delete table data and keep formulas If Not tblDataBodyRange Is Nothing Then tblDataBodyRangeDelete End If End Sub. Select the range you want to delete all data but formulas press Ctrl G keys simultaneusly to open the Go To. Assuming that you have a list of data in range B1C5 and you want to delete all data but only keep all your formulas.