If you're using relative cell references, then when you paste data is the formula changed to look at cells that are giving you a "" result and that's why it's blank? Just a thought. I can't tell without seeing it so I'm just throwing ideas at you.