Deleting rows below the end of a list that changes in length
Posted by Scott on January 23, 2001 5:10 AM
I have a spreadsheet that runs automatically every day. The sheet opens, runs a Macro to update my list of items (approx. 50) and saves the sheet. The list is imported from an external source and varies in length. The problem occurs when the list shrinks as the items on the bottom are not deleted or over-written. There is an entry at the bottom of the list called "End of list". I want to be able to script the deletion of any rows after this "End of list". If any one can help I'd
appreciate it. Thanks.