I'm referencing a code that was posted here: https://www.mrexcel.com/forum/excel-questions/983742-vba-delete-blank-rows-formula-but-has-no-value.html
Sub deleteBlankRows()
Dim lastRow As Long, lastCol As Long, i As Long, myBlanks As Long
With Sheets("Sheet1")
lastRow =...