Limiting ranges when building charts in vba
 

Hi.
I'm making quite a lot of use of this chat, so for all the answers so far, a
big thank you!
Now. I am builduing charts in vba with 3 different source ranges.
First question: is it possible to name the series after the ranges rather
than through their number?
Second, the soure series are named ranges that are not always totally filled
with data. How do I specify that the boundary of the range to take is the
last cell that contains data?
Thanks a lot