Hi Ramana,
the names are right, and I also got it to work in another sheet ... but I think I've solved it.
It appears the error message was coming up because I already had a header in the location I was trying to copy it to. If I delete the header (or move the target range down one cell) then it works.
Thanks for your help!
Bookmarks