Run time error 1004

Hi all,

I have been running this code with no errors for a while, but this keeps popping up now and I am unsure why:

Please Login or Register  to view this content.

I am getting "Run-time error '1004': You can't paste this here because the Copy area and paste area aren't the same size. Select just one cell in the paste area or an area that's the same size, and try pasting again.

With this line highlighted:

Please Login or Register  to view this content.

Any ideas why?

If there is just the one value in column B of the IMEI sheet, i.e. something in B2 but nothing in B3 or below, your xlDown command will copy from there to the very last row in the worksheet. When you try and paste that range into the Start sheet starting at row 3, it will go beyond the limit of Excel and it throws up an error. Microsoft are very well known for their error messages not being particularly helpful, and this is a prime example.

Give this version a try. It should do all your code does but will cope with there being just one value in either column.

Please Login or Register  to view this content.

It will obviously still fall over if you have values in EVERY row, but that's unlikely.

BSB

Excellent! Thank you so much BadlySpelledBuoy!

Happy to help

BSB