Giordano Bruno
Well-known Member
- Joined
- Jan 7, 2007
- Messages
- 1,352
I'm using Office 365 and have a workbook that uses the functions SKEW.P and STDEV.P. For some reason, the workbook keeps generating the hidden names "_xlfn.SINGLE" "_xlfn.SKEW.P" and "_xlfn.STDEV.P". This creates a problem as the code breaks if it finds these names when I try to remove all names using the following:
On Error Resume Next
For Each xName In Application.ActiveWorkbook.Names
xName.Delete
Next
I can avoid the code break by checking whether xName.Visible = True and then not deleting these names, but I would prefer to get rid of them or better still not have them intruding into my workbook in the first place.
Does anyone have any idea why these names are appearing and how to prevent it or, failing that, how to delete these names.
On Error Resume Next
For Each xName In Application.ActiveWorkbook.Names
xName.Delete
Next
I can avoid the code break by checking whether xName.Visible = True and then not deleting these names, but I would prefer to get rid of them or better still not have them intruding into my workbook in the first place.
Does anyone have any idea why these names are appearing and how to prevent it or, failing that, how to delete these names.