LINKED CELLS - want to leave linked cells behind?

[itr674]

When I copy a sheet from one workbook to another workbook and it has formulas in it the formulas want to link to the old book.

Is there anyway to stop this. I have to go back and delte all the links and it is driving me crazy ...
This message was edited by on 2002-10-18 09:38
This message was edited by em on 2003-02-09 17:35

 

[Andrew Poulsom]

This code will remove your links (quicker than you can manually):

Sub Test()
    Dim Rng As Range
    Dim c As Range
    Set Rng = ActiveSheet.Cells.SpecialCells(xlCellTypeFormulas, 23)
    For Each c In Rng
        If InStr(1, c.Formula, "[") Then
            c.Value = c.Value
        End If
    Next c
End Sub