I have a ton of columns in an excel sheet with pretty intensive formulas (countif) in the rows. I need to copy the rows (formulas within) over about 400,000 rows. Excel 2007 is giving me a ton of trouble related to memory, so I was hoping to find a quick macro that would copy rows in a different way. Any help you could give me would be greatly appreciated.

Also, its important to note that the entire row won't be copied, only, for instance, columns 200-260.

Thanks so much for all of your help

Sincerely,

Michael