copy limit?
Why did you not copy the entire worksheet in one fell swoop?
"mark" wrote:
Hi.
I'm working with a ridiculously large number of formulas.
I manually copied/pasted items on rows C through GK to about 2500 rows.
Each time, it works fine down through row 1045, and then pastes part of row
1046, and quits.
I counted the number of cells that received the paste, and it's 198,300.
Even. I think consistantly.
Does this sound like an Excel limit? Or a system resources limit?
I have another way to do it, but am curious about what the problem is.
|