Excel Cell Reference

[tomberlins]

I have a some cells in a workbook that reference data tabs in the same workbook. Before this workbook is passed on to the end user, the data tabs are deleted. Once the data tabs are deleted the referenced sells obviously lose the referenced value. Is there a way, besides pasting special values, to keep the value in the cells once the data tabs are deleted?

[sweep]

You could run a section of code to convert the cell contents to values.

Sub a()
For Each rCell in Selection
rCell.Value=rCell.Value
Next
End Sub

Will convert formulas to values in the currently selected cells.