I am recording a macro which includes taking a text string and using th
mid function to extract 7 characters from this string. Once I hav
performed the function, I then need to copy it down the remainin
cells. This works fine on the current download of my file, bu
subsequent downloads vary in terms of the number of rows. I have trie
copying the formula down to row 65,536 to ensure it picks up all activ
rows but now I am left with thousands of blank rows which I would lik
to delete. Is there a way of copying the formula to the last activ
row or is there a way of deleting all rows after the last active row.

Thanks

Shirle

--
Shirley Munr
-----------------------------------------------------------------------
Shirley Munro's Profile: http://www.excelforum.com/member.php...info&userid=83
View this thread: http://www.excelforum.com/showthread.php?threadid=42613