Ideally, according to the documentation, DeleteBlankRows() should delete only rows which are empty i.e. the rows which does not have any content, images, charts, comments etc…
But in the attached file below, Even the r…...If you want to remove all formulas, please use Cells.RemoveFormulas()...worked for the older file I have shared. Please find the solution attached...