Sorry, no other idea, a valid UsedRange exists so I don't see any other reason why your macro could go wrong.
Maybe if you attach a dummy 'not working' file (just a few rows of data).