I need to download a file on a regular basis and this number of rows in the files varies each time it is downloaded. I am using a macro on column B to carry out the MID function on column A. Once the function has been carried out I then need to copy the formula down all of column B as I don't know what the last active cell will be from one download to the next. The result is that I have thousand of excess rows which I need to delete. Can anyone give me code that will delete all rows from the last active cell onwards.

Thanks

Shirley