Can you attach a small sample workbook? I find it hard to visualise things like this. You might be able to use CurrentRegion or Areas.