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…...sample code, we can obtain the correct results. Please refer to the...screenshot and highlight the error location, it will be very helpful...