"Elkar" wrote:

Select any blank cell and "Copy" it. Then select all of your hyperlinks that
you want to replace (or columns, or worksheet). Then select "Paste Special".
Under the "Operations" section, select "Add". That should do it.

Thanks. Looked neat, but didn't work!

--
Terry, West Sussex, UK