I have a workbook that has 100+ names in the name manager. The formula is essentially all the same formula. It is an offset that references different cells. I have to change the formula. Is there a way to do a mass change instead of one by one? The beginning part of the formula remains the same, something towards the end of it is changing. I have several workbooks with the same issue.