Then I'm not sure what you want. Post an example of a before and after range, either in a workbook or with screen captures.