Skip to content

Instantly share code, notes, and snippets.

@prdpspkt

prdpspkt/removeNamedRanges.vb

Created April 18, 2019 03:54
Show Gist options
  • Save prdpspkt/8b8025613b889a01eced4dbfe1f19e53 to your computer and use it in GitHub Desktop.
Save prdpspkt/8b8025613b889a01eced4dbfe1f19e53 to your computer and use it in GitHub Desktop.
Download ZIP
Remove Named Range in Excel using VBA
Raw
removeNamedRanges.vb
Private Sub Workbook_Open()
Dim i As Long
Application.Calculation = xlCalculationManual
For i = ThisWorkbook.Names.Count To 1 Step -1
ThisWorkbook.Names(i).Delete
Next
Application.Calculation = xlCalculationAutomatic
End Sub
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment