You can use SpecialCells to find cells which are not blank, and you could then copy that range which would be contiguous.