the blank rows appear below the results not in them, it doesn't matter what the range is. You can see the scroll bar on the right getting smaller and smaller on the master and export sheets as more 'used' rows end up at the bottom after each click. I had to go in and delete about 400 of them then realised it was adding them every time the macro is clicked. on the master sheet, if I drag the scroll bar to the bottom, the last row I can see with my screen and resolution is row 69. if I click the macro then drag the scroll bar to the bottom, the last row is then 72. click again and the last row is row 75. It is adding 3 rows each time and I am guessing this is somehow related to the fact that the first 3 rows of any of the sheets are the header rows.