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?
You could run a section of code to convert the cell contents to values.
Will convert formulas to values in the currently selected cells.Sub a() For Each rCell in Selection rCell.Value=rCell.Value Next End Sub
Please disregard anything in the above post. It may well have been edited without my consent, as has been the case with several posts and threads recently.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks