You could use a macro.

Gord Dibben shared this:

http://groups.google.co.uk/group/mic...60f32287258372

or

http://snipurl.com/1g005



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

--

Dave Peterson