VBA Exportasfixedformat multiple pages all wrong sizes!!

morning,

I have the following code which exports a selected range of tabs and exports to pdf:

Please Login or Register  to view this content.

The problem I am having is that the page sizes of the pdfs (supposed to be all A4) are completely different. Some are at least 5 times the size of the previous or subsequent pages.

Has anyone seen this before?

When I select the pages manually and print to pdf everything is fine?

thanks in advance.
Dan.

can anyone help please?

thanks,
dan./