Posted to microsoft.public.excel.programming

external usenet poster

Posts: 489

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Subscript out of range error message	Ayo	Excel Programming	3	April 28th 09 10:29 PM
Error Message "Subscript our of range"	gsmclang	Excel Discussion (Misc queries)	1	April 5th 07 06:59 PM
FileCopy Command Giving "Subscript Out of Range" Error Message	Jim Hagan	Excel Programming	2	June 15th 05 06:07 PM
Subscript Out Of Range Error Message	Bob Umlas[_3_]	Excel Programming	1	July 28th 04 07:00 PM
Subscript Out Of Range Error Message	Tod	Excel Programming	0	July 28th 04 06:24 PM

All times are GMT +1. The time now is 08:55 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us