Thanks, that's works fine and copies column D but I now want to select D only. I don't see why the macro recorded method works but the vba way doesn't. Any suggestions?
Thanks.