I deleted the Styles on a worksheet using the below code
The problem is after it deleted the styles I can't see the data but it is there. Is there a way to reverse the delete so that I can see the data?Sub DeleteStyles() ' DeleteStyles Macro Dim styT As Style Dim intRet As Integer For Each styT In ActiveWorkbook.Styles If Not styT.BuiltIn Then styT.Delete End If Next styT MsgBox "Macro has completed running" End Sub
What type of file, xls or xlsx?
Don't think so. You could merge the styles from another workbook, but the cells that used those styles have reverted back to style Normal.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
maybe you have the cell font set to the same as the background or a custom number format that is hiding the data. try clearing all formatting from the cells or check the settings for the Normal style as shg mentioned.
"for reals"-only used in rap and discrete math
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks