how to stop created sheet from linking to another sheet

[Dwayne]

Hi guys / gals,
I got my shipping bill program running great, with just one little
problem. My Sold to and Ship to fields use if statements in formulas,
and of course, when I create a shipping bill from this Excel sheet, if
I make any change to the Master, the 'child' sheets also update. I
guess I need a way to brake the link, or if there is a programatic way
to turn the formula values into plain text other then recreating all of
my formulas in Excel to lines of code in VBA.

 

[Dwayne]

Just found a solution:


Dim cell As Range
For Each cell In
Worksheets("Sheet1").Cells.SpecialCells(xlCellTypeFormulas)
If Not IsDate(cell.Value) Then
cell.Value = cell.Value
End If
Next

 

[Dwayne]

Just found a solution:


Dim cell As Range
For Each cell In
Worksheets("Sheet1").Cells.SpecialCells(xlCellTypeFormulas)
If Not IsDate(cell.Value) Then
cell.Value = cell.Value
End If
Next