I bet it only ever pastes to the contiguous cells. But maybe you got lucky in
that all the visible cells were contiguous.

Holly wrote:

Why sometimes paste special under a filter only paste to the filtered rows,
but sometimes are pasted to all the unfiltered rows?

--

Dave Peterson