I am dealing with a macro that makes several graphs. The label for the
lines of the graphs depend on the number attached to the name of the
file. I do not want to have to go into the VB code and find and replace
the numbers for each of them. Is there anyway I can write this at the
top and have it go for each of them? I tried this earlier with no
sucess, but I will post it to help you better understand what I am
talking about. It looked something like this:

Dim plot300K as Name
plot300K = "13T300K2per0500"



ActiveChart.SeriesCollection(1).Name = "=""plot300K"""


--
Losse
------------------------------------------------------------------------
Losse's Profile: http://www.excelforum.com/member.php...o&userid=24813
View this thread: http://www.excelforum.com/showthread...hreadid=386782