Even simpler in my estimation.

Copy an empty cell.

Select the hyperlink cells and Paste SpecialAddOKEsc.


Gord Dibben Excel MVP

On Wed, 4 May 2005 11:10:06 -0700, "MWDixon"
wrote:

The simplest way I can think of to remove the hyperlinks off of a long list
after they are created, would be to copy the range of cells, go to a blank
part of the sheet and EditPaste SpecialValues (you can leave the other
settings at their default). You can then immediately do a cut and regular
paste back to the original range of cells