Hi,

You can do it by find and replace if you have any question give me an
example then i explane based on your example.

Thanks,
--
Farhad Hodjat


"PZ" wrote:

I know how to use F4 to cycle through reference choices for a single cell.

Does anyone know how I can do that for a *very* large *range* of cells? It'll impact something in the neighborhood of 500+
cells.

Thanks, in advance

Phil