I am a basic user of Excel 2003. I recorded a macro in my Master worksheet to copy and pasted a range of information into my Cover worksheet. My dilemma is what function makes the target range of the Cover worksheet move down x number of rows if the previous range is in use.