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?