Ahh, I thought I was saying take the cells for the range in sheet17, but what it is interpreted as is the cells in the activesheet, and it’s .range which it may not connect to the with. I have seen examples of code where the dot occurs in more than one place on a line, always referencing back to the with command, but I do understand that if the first item stands alone then confusion reigns throughout. Would something like that if run through on various attempts be enough to cause a crash?