Trouble Coping Visible Cells

[Guest]

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?

 

[Norman Jones]

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.aspx?scid=kb;en-us;832293

 

[Dave Peterson]

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).