Hi. I have hundreds of formulas that generate hyperlinks and I want to copy and paste the hyperlink, not the formula. Is there a way of doing this? When I use paste special, value, it doesn't include the hyperlink. Any ideas appreciated. Cheers, Guy.