Sheet import macro stopped working.

Hello, I have been using this macro succesfuly for some time now and today it decided to not work. Can someone help me troubleshoot it?

It fails on this line:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I have included the workbook that contains the macro and a sample import workbook.

Here is the link to the original thread:
http://www.excelforum.com/excel-prog...readsheet.html

Thanks for any help you may be able to provide!

No sample data makes testing your macro troublesome for us, at best. Much better to simply replace sensitive data with generic entries...Name1, Name2, etc.

Your macro runs for me, but I have no data to verify it's accuracy. It doesn't stall at the point you've noted.

Maybe:

Please Login or Register  to view this content.

Sorry, of course it is. My bad.

The macro seems more complex than is necessary. Try this, it copies the columns of data all at once, and adds the formulas in columns U and V, too:

Please Login or Register  to view this content.