Subscript out of range error message

A

Ayo

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subscript out of range error message 3
Setting maximum and Minimum Scale for the Category axis 0
Worksheet_SelectionChange & Worksheet_Change results in different Targets 2
Macro converts time entered in column E and F from Indian time to CST( without daylight saving) 1
Help with Worksheet_Change;section of code not woring as expected 1
how to have 2 drop down lists filter rows 2
From Excel to user form 0
Highlight a cell after update in a specific range 2

Top