Funny I thought the OP's problem was
to update my code below to only copy the visible cells and exclude the header row
that is why one would use the Offset(1, 0). Cant see why one would use Offset(0, 0) unless one wanted to include header row.

Alf