It could also be that there was data OUTSIDE the named range.
I managed to solve such an error today and my code worked again.
My range included rows 1 to 60, but there was data at row 300.
Thanks for your answer in 2006, it gave me a hint in 2015.
I had run-time error 3226 when I used a...