I tried this before and now tried it again after getting confirmation from you with the same result.

When the headings are on Row1 the export works fine. When the headings are moved to Row5 and the code is changed to Row(5) the export sheet is created but it is BLANK.

Any suggestions?