I know, I know...but yes, another one !
I've seen various methods for this but all of them give me a RunTime
Error. If I select the cells with a formulae in and use a For/Next
loop to change each of those cells individually then it does work BUT
it takes about 5 minutes to do it. Every thing else fails.
I've tried....

1.) .UsedRange.Value = .UsedRange.Value
2.) .UsedRange.Formula = .UsedRange.Value
3.) Selection.Copy
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone,
SkipBlanks:= _
False, Transpose:=False
4.) Set rng = Columns("B:BM").Cells '.SpecialCells(xlCellTypeFormulas)
rng.Value = rng.Value

I have a lot of cells with formulae in a lot of cells with links in.
It's the links I really need to remove, the internal formalue can stay
if need be.

Can anybody suggest any alternatives that I have not tried yet.

These cells that I want to remove the links/formulae in are dotted
around the worksheet and are not therefore continuously next to each
other.

Thanks for any suggestions you can give.
Donna