Hi guys,

I've got a range of cells that i am trying to copy into another workbook. Problem is the workbook i'm copying into contains formulas and validations dependant on the cells i'm copying into. Some of the cells i am trying to copy are blank and some are not, for some reason the blank cells that are being copied in are being treated as non blank and are throwing all the formulas out.

Any ideas? I've tried using the Paste Special options but none appear to solve this problem.

Cheers