2010 macro not working in 2013 via button

The macro in the attached file combines the data from the tab 'email' and the tab 'website' into the tab called “combined”.

When it's run in Excel 2010 the button gives the same result as when it's run via the editor. In Excel 2013 however, the button gives a different result than if I run directly from the editor but I cannot figure out why?

Macro export.xlsm

My guess, it is less to do with the version of excel, but more likely you have lots of "Select" and Activate" methods and properties in your code.
Or you may have missed a dot with end with statements.
If you have active cell or sheet, the code may/ may not work, depending on where the "Cursor" is while running by pressing a button may give you a different result as your cursor is on it. Try to avoid using "Select and active" unless you can not.

Hi Paulie,

Take a look at the attached workbook and see if it does what you need.

As the previous post pointed out, the Activate and Select methods should not be used unless they are really necessary, but not using these methods means that you need to use fully-qualified references throughout your code - it is no longer possible to assume that the worksheet which currently happens to be active is in fact the one that you want your code to operate on!

Anyway, I hope the attached is of some help to you - please let me know how you get on.

Regards,

Greg M