i have a huge excel spreadsheet with blank lines mingled with lines with text. I want to write a macro that will leave the lines with text and delete the lines which are blank. I know how to do the last part. Is there an easy way to check if a line has some text in it (any cell but same row)?

any insights will be greatly appreciated. Thanks.