Updating macro to Excel 2010

I have a macro which was developed in Excel 2007 (version 12.0?). When I run it in Excel 2010 (version 14.0), I get some inconsistent errors as follows:

I have this code operating on one worksheet:

Please Login or Register  to view this content.

which is acceptable. A little later, I have, operating on a different worksheet:

Please Login or Register  to view this content.

which gives a run-time error '1004': Paste method of Worksheet class failed.

Commenting that statement out and running again. I have this code:

Please Login or Register  to view this content.

which runs OK. A few lines further on:

Please Login or Register  to view this content.

fails with a run-time error '91': Object variable or width block variable not set.

What's happening and how do I fix it? These appear to be the only sources of run-time error.

I'm running the macro in Windows 7 on an ASUS Eee Slate. I can't test it anywhere else.

Hi Audax,

Please take a moment to review the forum rules and then amend your thread to add [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags around your code.

Thank you.