This should be a simple macro, I just don't know how to write them. I have data starting at row 9 and going through row 210. currently data only fills down to row 100 and I have formatting that colors every other cell down to 210. It wouldn't be hard to just scroll down and delete everything after the last row with data, but a macro would make this easier. So I need a macro that searches down column A and deletes all rows starting with the frist blank cell. I have a header in rows 1-8 so I need this macro to start on row 9. Thanks in Advance.
Bookmarks