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


--
Shirley Munro
------------------------------------------------------------------------
Shirley Munro's Profile: http://www.excelforum.com/member.php...nfo&userid=836
View this thread: http://www.excelforum.com/showthread...hreadid=469489