I have a macro that wants copy a range from one sheet to the end of a long list on another sheet. Simply enough eh? The problem is how to get excel to find the end of the list so you can paste the new data in the rigth place. Every time you run the macro the end of this list will shift down.