Ahh thanks,

I am copying rows from columns B, C, and, D but they go up to H with a table to the side of H which uses information going back over 600 rows to calculate things. I can't really add a column in without messing historical calculations up.

How can I get around this?

Thank you so much for your help.

Phil