What happens if the criteria are not found? Will the offset still works? How can VBA copies data if it could not find any visible cells, hence the error? The offset is just a way of skipping the first cell in the range.