Chart Title from Dynamic Range Issue

My first post and I'm a novice user so please excuse any naivete on my part.

I'm writing (using) some code to parse out multiple sheets that will in turn chart mulitple data sets. I can't, for the life of me, get the charts to show the dynamic titles and I'm not even sure if there's a way to make it happen. Everything else works, but the titles, which I would like to use a range of 3 cells, starting with A2:C2 on each sheet. I'm working Excel 07 but can get it on '10 if need be. Here's the code - thanks for any help you may have!

Please Login or Register  to view this content.

Thanks for the reply - I fixed it by ditching the range reference and converting the whole thing to a string and looping it for my sheet.

Please Login or Register  to view this content.

Pretty amateurish, but it works. Thanks again for the quick reply!