Hi. Perhaps I can assist.
What exactly are you exporting--and why should something as straightforward as an export require a customized macro?
I never heard of an "export" exporting only one row. Clearly, something is very wrong.
Could you possibly give me a bit more detail about PRECISELY WHAT you are "exporting" and what YOU interpret "exporting" to mean.
Thank you for your detailed cooperation.