ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Subscript out of range error message (https://www.excelbanter.com/excel-programming/427677-subscript-out-range-error-message.html)

Ayo

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


All times are GMT +1. The time now is 12:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com