Hi,

First off, this is wrong:

Range("A:A:D:D")
Are you looking for:

Range("A:D")
Additionally you are trying to copy a large range into a smaller range. Can't do that either. The ranges have to be the same.