Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Subscript out of range error message
I am trying to run this code:
Private Sub Worksheet_Change(ByVal Target As Range) Charts("Milestone Chart").Activate With ActiveChart .HasTitle = True .ChartTitle.Text = Range("B3") & " " & Range("B4") & " - NLP2" '"First Quarter Sales" End With Application.ScreenUpdating = False If Target.Address() = "$B$3" Then Call getMSaddress(Target) ElseIf Target.Address() = "$B$4" Then Call getMSaddress(Target) End If End Sub but I am getting the error message on: Charts("Milestone Chart").Activate I don't know why this is since I named the chart "Milestone Chart". Any ideas. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error Message "Subscript our of range" | Excel Discussion (Misc queries) | |||
Subscript out of range error - save copy error | Excel Programming | |||
FileCopy Command Giving "Subscript Out of Range" Error Message | Excel Programming | |||
Subscript Out Of Range Error Message | Excel Programming | |||
Subscript Out Of Range Error Message | Excel Programming |