Hello Everyone,

I want to change every formula on a particular worksheet that includes the sub-expression "+$c$8".

I want to substitute "+$b$48" for "+$c$8" in all those formulas, without altering the rest of those formulas, most of which are different from each other.

I've tried to use Find/Replace, but it can only find the "+$c$8" sub-expression in the one particular row that happens to be selected at that time

Changing the Find/Replace option from "Search by rows" to "Search by columns" means that it can only find the sub-expression in one particular column.

I want to find and replace this sub-expression in every formula where it appears in this worksheet.

What to do?

Cheers, Jay