What would be a good marco to write so i could remove blank lines in excel. For example i have a sheet with all the colums filled up then down at 47 it blank all the way accross listing the totals. I want to write something that deletes that line and the total txt. Im sure its simple I am completely new to doing this