Deleting Custom View with VBA

[jmpatrick]

I have code that creates a Custom View with a name pulled from Sheet:

ActiveWorkbook.CustomViews.Add Range("Load!D1").Value, False, True

Works great.

Is there a way to delete the same way? This doesn't work for me:

ActiveWorkbook.CustomViews.Delete Range("Load!D1").Value, False, True

 

[MDCurry]

This worked for me:

Sub test2()
 Dim View1 As String
  View1 = Range("Load!D1").Value
  ActiveWorkbook.CustomViews(View1).Delete
End Sub

 

[jmpatrick]

Thanks, works great!