We copy visible cells all the time; however, we are trying on a certain
spreadsheet and it is not working. This file is larger than most that we use
this function on and I was wondering if anyone knew of a limit of the number
of rows that can be copied and pasted using the copy visible cells function?

Hi Jen,

I suspect that you have hit the 8192 non-contiguous special cells limit.

See the MS Knowledge Base article 832293:

http://support.microsoft.com/default...b;en-us;832293


---
Regards,
Norman



"JenYancey" wrote in message
...
We copy visible cells all the time; however, we are trying on a certain
spreadsheet and it is not working. This file is larger than most that we
use
this function on and I was wondering if anyone knew of a limit of the
number
of rows that can be copied and pasted using the copy visible cells
function?

And if it is this problem, maybe you can sort your range first. If you're
lucky, then the number of non-contiguous areas will be reduced (to under 8192).

Norman Jones wrote:

Hi Jen,

I suspect that you have hit the 8192 non-contiguous special cells limit.

See the MS Knowledge Base article 832293:

http://support.microsoft.com/default...b;en-us;832293

---
Regards,
Norman

"JenYancey" wrote in message
...
We copy visible cells all the time; however, we are trying on a certain
spreadsheet and it is not working. This file is larger than most that we
use
this function on and I was wondering if anyone knew of a limit of the
number
of rows that can be copied and pasted using the copy visible cells
function?

--

Dave Peterson