ExcelBanter - Replacing links with values

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Replacing links with values (https://www.excelbanter.com/excel-programming/285477-replacing-links-values.html)

John[_68_]

Replacing links with values

Does anyone know a quick way to remove a link in a cell
with the value of the cell? Can this be done using VBA?
Thanks.

john

Replacing links with values

Found out there you can break links using edit|links

-----Original Message-----
Does anyone know a quick way to remove a link in a cell
with the value of the cell? Can this be done using VBA?
Thanks.
.

All times are GMT +1. The time now is 03:12 PM.