Funny I thought the OP's problem was
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.to update my code below to only copy the visible cells and exclude the header row
Alf
Bookmarks