My workbook has more than 50 worksheets.

I need a VBA to find all values over 100% and change them to 100% in all sheets. The sheets do contain other numeric values, but only one column with percents.

Note - The percents on all sheets are created by a formula that divides two values. If the division of the two values results in an error there is an iferror addition to the formula that leaves a specific phrase. if needed to run the VBA I can first remove all formulas to leave values only.