Thanks so much for this code. It has really helped me a great deal.

I am having one problem. When I pull a small amount of data, 5 to 10 rows, the headers are appearing at the top of the spreadsheet. When I pull about 400 rows the headers appear about 50 lines down in the spreadsheet.

Do you have any ideas how this could happen?

Thanks!