View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ayo Ayo is offline
external usenet poster
 
Posts: 489
Default Subscript out of range error message

Why am I getting this error message?

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address() = "$B$3" Then
With Charts("Milestone Chart")
.HasTitle = True
.ChartTitle.Text = Range("B3") & " " & Range("B4") & " - NLP2"
End With

End If