Martin -

using Ctrl+H would only find and replace "LoB1", it would not extract the cell part of the reference ("K44" in the example above) and past it back into the new formula.

Richard's Macro solves this problem.

Rgds,
Alain