Hello Martin
I looked in Metalink but couldn't see anything specific to that error number. However, as a bit of a long Shot, have you checked the security settings within Excel:
Go to Tools -> Macros -> Security
In the 'Security Level' bit, you are at least at 'Medium'
In the 'Trusted Publishers' bit, you have 'Trust Access to Visual Basic Project' enabled.
I'm not 100% confident of this as it does work for single rows, but even so, perhaps worth checking?
Good luck anyway, and if you do find the answer please share it with us!
_________________________
L&K
CT