When I try to delete the TableX name in name manager the delete option is greyed out. Do you know how I can fix that?
I have tried numerous programs and vba code to delete the TableX named range without success. Each and every one of the solutions tried doesn't recognize the name range and/or doesn't show it in the list of available names.
On of the vba codes I tried is:
Dim wb As Workbook
Dim nr As Name
Set wb = ActiveWorkbook
Set nr = wb.Names.Item("TableX")
' give an absolute reference:
nr.RefersTo = "=MasterData!$A$3:$G$400" error reads Run-time error'1004' Application defined or object-defined error
End With
I am not sure where to go now. Maybe you have an idea?